Save as CSV problems
 

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:

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:

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: