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.

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

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