Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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: |
#2
|
|||
|
|||
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: |
#3
|
|||
|
|||
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: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't save Excel using Save button, | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |