Saving csv files

S

Steve

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.
 
D

Dave Peterson

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).
 
S

Steve

You're exactly right. Thank you.

Dave Peterson said:
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).
Click to expand...
 
Top