T
Thejaswini
have a page wherein the contents of a datagrid are
exported to an excel file. All the columns are correctly
displayed in excel except for the number columns. The
formatting string for the number column is {0:#,##0.00;
(#,##0.00);0.00}. The data is formatted for all numbers
exceeding 1000 but for any number below 1000 the data is
displayed as 1000 and not with 0's in the decimal places.
(displayed as 999 instead of 999.00).
exported to an excel file. All the columns are correctly
displayed in excel except for the number columns. The
formatting string for the number column is {0:#,##0.00;
(#,##0.00);0.00}. The data is formatted for all numbers
exceeding 1000 but for any number below 1000 the data is
displayed as 1000 and not with 0's in the decimal places.
(displayed as 999 instead of 999.00).