Skip to Content
Former Member
Mar 09, 2007 at 10:13 AM

Problem in Excel Download Formatting


Hi all,

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.