Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why will Excel will not save text format in a .csv file
In Excel .csv file,
I format cell as text enter 001 and save. Reopen and everything is reformatted as general and cell shows 1. Can this be fixed? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why will Excel will not save text format in a .csv file
If you open the .csv file in notepad (or any other text editor), what do you
see. Just because reopening the file in excel loses the leading 0's, it doesn't mean the SaveAs didn't work correctly. If you want to preserve formatting, then saving as a .csv file isn't the way to go. If you want to see what the .csv file looks like, then reopening using excel isn't the way to go. davis wrote: In Excel .csv file, I format cell as text enter 001 and save. Reopen and everything is reformatted as general and cell shows 1. Can this be fixed? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save in Multiple format crashes Excel 2000 SP3! | Excel Discussion (Misc queries) | |||
Importing text file to excel | Excel Discussion (Misc queries) | |||
Excel XP: File name in Title Bar not changed after Save As... | Excel Discussion (Misc queries) | |||
How to save an excel spreadsheet as a text file without added quot | Excel Discussion (Misc queries) | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) |