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



Posted by Mark W. on September 17, 2001 11:16 AM

Instead of using the .csv extension use .txt. Next,
open the file from within Excel using File | Open...
menu command (or Control+O). This will activate
the Text to Column wizard. At Step 2 of 3 choose
the "Comma" delimiter option. At Step 3 of 3
specify "Text" formatting for both columns.