Saving csv files

[Guest]

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]

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

 

[Guest]

You're exactly right. Thank you.

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