Article relates to
04 March, 2009
Last modified by
SOLUTION By default Excel uses the thousands separator from the regional settings of the operating system. It is modified from Control Panel > Regional and Language Options > Digit grouping symbol.
If you want to use the digit grouping symbol of the Excel and not the system separators you will have to make sure that the check box “Use system separators” is not checked.
Note: At this moment, custom numeric strings are not supported in Excel rendering. More information about this you can find here.
As a workaround you can either use the Standard Numeric Format Strings if applicable or use an expression or a user defined function to return already formatted string. For example: =Fields.Price.ToString('#,#0.####')