View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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