Thousand separator in export to Excel

DESCRIPTION

When exported to Excel the thousands separator is not the same as it is set in the report.

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.

• In Excel 2007, this option is located in Excel Options > Advanced

 

• In Excel 2003, this option is located in Tools > Options > International

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.####')