hi,
i have used ("#,##0.00) format to show price 10000 as 10,000.00
It show good format in Grid but when i export this to Excel then this value is shown as 10000 not as 10,000.00.
however if the character length is greater than 5 digits (10,0000) then both in grid and export to excel it shows good format
as 10,0000.00
So please provide me good solution so that in Excel i can also see good format for character less than 6 digits also.
Thanks & Regards,
Alokssm