I am facing some formatting problems for the excel download.
I have used the following tag to download the number data.
<NumberFormat ss:Format="Standard"/> which is displaying the data with decimals. The value '0' is displayed as '0.00'. In order to change the format as per my customers requirement i have changed the above tag to the following format.
<NumberFormat ss:Format="General"/> which is ignoring the zeroes after the decimal point as per requirement. But the problem is the amount 22,000 is displayed as 22000 i.e. without comma separator.
How can i include the comma separator for the values.
Thanks in advance.