Specify Custom Number Decimal and Group Separators for Workbook

In Microsoft Excel, you can specify the Custom Decimal and Thousands Separators instead of using System Separators from the Advanced Excel Options as shown in the screenshot below.

Aspose.Cells provides the WorkbookSettings.NumberDecimalSeparator and WorkbookSettings.NumberGroupSeparator properties to set the custom separators for formatting/parsing numbers.

Specifying Custom Separators using Microsoft Excel

The following screenshot shows the Advanced Excel Options and highlights the section to specify the Custom Separators.

todo:image_alt_text

Specifying Custom Separators using Aspose.Cells

The following sample code illustrates how to specify the Custom Separators using Aspose.Cells API. It specifies the Custom Number Decimal and Group Separators as dot and space respectively.

C# code to specify custom Number Decimal and Group Separators

List of Supported Number Formats Render Custom Date Format Pattern g and ge mm dd