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.
Jus55
Member
740 Points
148 Posts
Download DataGrid to Excel
Apr 14, 2005 08:42 PM|LINK
Hi,
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.
Thanks