Issue with Export To Excel
-
Hi Guys, I am working on VB.NET/Access. Consider the data 0000011. I am writing the data in CSV format to a file. When I open the file with notepad, the data looks correct. However, when I open in excel, the leading zeros are truncated. It appears as a number. how do you write such data to open correctly in excel. With Best Regards, Mayur
-
Hi Guys, I am working on VB.NET/Access. Consider the data 0000011. I am writing the data in CSV format to a file. When I open the file with notepad, the data looks correct. However, when I open in excel, the leading zeros are truncated. It appears as a number. how do you write such data to open correctly in excel. With Best Regards, Mayur
You need to convert the cell to 'Text' format and not 'General'. By default excel will automatically exclude leading Zero's in a 'General' Formatted Cell! Highlight the whole column and right click, select 'Format cells' and change the format to 'Text'. Hope this helps. Gary
-
You need to convert the cell to 'Text' format and not 'General'. By default excel will automatically exclude leading Zero's in a 'General' Formatted Cell! Highlight the whole column and right click, select 'Format cells' and change the format to 'Text'. Hope this helps. Gary
Even if I convert the cell to TEXT, the result is the same. With Best Regards, Mayur
-
Even if I convert the cell to TEXT, the result is the same. With Best Regards, Mayur
It Will be! You need to use the import wizard in excel and select the cell type to be text. If you load the file then try changing the column to text it will not do anything, as the leading zero's have already been taken out.