Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving csv files
In a cell I have 65.50 and have given it a number format of "00.00" and saved
it as a csv file. When I save a csv the 65.50 becomes 65.5. I'd like to keep the ending zero. |
#2
|
|||
|
|||
Look at your CSV file using NotePad.
I bet you have your 65.50. But when you reimport that CSV file into excel, it uses a general format. You can always reformat that range after you reopen the workbook (if you have to). Steve wrote: In a cell I have 65.50 and have given it a number format of "00.00" and saved it as a csv file. When I save a csv the 65.50 becomes 65.5. I'd like to keep the ending zero. -- Dave Peterson |
#3
|
|||
|
|||
You're exactly right. Thank you.
"Dave Peterson" wrote: Look at your CSV file using NotePad. I bet you have your 65.50. But when you reimport that CSV file into excel, it uses a general format. You can always reformat that range after you reopen the workbook (if you have to). Steve wrote: In a cell I have 65.50 and have given it a number format of "00.00" and saved it as a csv file. When I save a csv the 65.50 becomes 65.5. I'd like to keep the ending zero. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving files with mapped drives | Excel Discussion (Misc queries) | |||
FILES CREATED AUTOMATICALLY WHILE SAVING | Excel Discussion (Misc queries) | |||
Saving Office files on a network | Excel Discussion (Misc queries) | |||
Extra files when saving | Excel Discussion (Misc queries) | |||
Saving shared Excel files | New Users to Excel |