In a .csv file everything is saved as text, and remains as text.

If you're importing the text file back into XL, and you want XL to
interpret the field as text rather than a number you can use the
Data/Get External Data/Import Text File... wizard (with WinXL, you'll
have to change the extension from .csv to .txt) to designate the field
as text rather than General.


In article ,
"Oded Dror" wrote:

Hi there,

I'm using Excel 2003 and Windows XP Pro. SP2

I have book.xls file with names and numbers like fname lname salary

John Smith 100.00

when I save as book.csv the salary column become a text (100 in the left
side of the column)
Just the way I wanted I click ok. and close

Now when I'm reopen the book.csv file again the column salary become as a
number again
(100 in the right side of the column)

How can I fix this issue (If I save the file as a text I wanted be remain as
a text )

Thank you an advanced.

Email: