View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default Maintaining Number Formats from Excel to CSV File Conversions

Laura

Try formatting the data to text before saving

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"laura1027" <u34668@uwe wrote in message news:7303faee8b1d9@uwe...
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