Specify Custom Number Decimal and Group Separators for Workbook

Specifying Custom Separators using Microsoft Excel

  1. Open Options in the File tab.
  2. Open the Advanced tab.
  3. Change the settings in the Editing Options section.

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


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. So the number 123,456.789 will be displayed as 123 456.789 as shown in the screenshot which shows the output PDF generated by the code.