Apr 14, 2005 04:42 PM|Jus55|LINK
I have an asp page where users can download datagrid to excel sheet. Its working fine but there is an issue. I have a char field on the grid which may or may not have zero's in front. The problem is when I download this sheet to excel, It ignore zero's.
For example if its showing 01567 in a cell in the datagrid, it will download this number as 1567 to excel. How can I fix this issue? I need to download that number as 01567 with zero's to excel.