Oded,

Everything saved in a csv is text characters. There's no indication of text
or numbers or anything. It's Excel that's interpreting it as a number ("it
looks like a number, so it must be a number."). You can change the file
extension from .csv to .txt. Now when you open it, it will invoke the
import wizard, where you can specify which fields are to be text.

Or if you want to read the text file into an existing worksheet, you can use
import. Details on all this at www.smokeylake.com/excel. Read "Excel and
text files."
--
Earl Kiosterud
www.smokeylake.com


"Oded Dror" wrote in message
...
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: