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.####')
Copyright © 2017, Progress Software Corporation and/or its subsidiaries or affiliates. All Rights Reserved.
Progress, Telerik, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks or appropriate markings.