Are you sure?

If you re-open that CSV file in excel, then formatting will be gone.

But what do you see if you open the CSV file in NotePad?

It's not the saving as CSV that's the problem, it's the reopening within excel
that's the problem.

laura1027 wrote:

Scenario:

Converting an Excel File to a CSV File. Saving on a disk and than downloading
it to a DOS program.

Problem:

When I convert the excel file to the CSV File and save, it does not save the
same number format.

Example:

In Excel, the number format is 6.90 or 33.00.
After converting to a CSV file for upload to a DOS program, the 6.90 changes
to 6.9 and the 33.00 changes to 33 - the ending zeros disappear.

Question:

How can I maintain the numbers with the ending zeros after the decimal point?

Any Solutions?

Thank-You

--

Dave Peterson