excel .csv file
Posted by Dan Liu on September 17, 2001 7:34 AM
Hi, All
I have a .CSV file, which created using notepad, and it looks as following:
column1,column2
1.1,2.1
1.10,2.10
1.11,2.11
When I open the file using Excel, then save as .CSV file through the Excel, the file looks like following:
column1,column2
1.1,2.1
1.1,2.1
1.11,2.11
As you can see, the "0" of "1.10" and "2.10" are lost.
I know the problem is that when I open the file use Excel, excel drop the "0" atomatically.
My question is that, is there any way to perserve "0" in my file opened in Excel.
It's impossible to manually format the cell in Excel when the file getting big.
Thanks for your help. / dan