csv format changes numbers

B

Bobbr

I need to save my file in a csv format. When the file is reopenned, some of
the numbers are in a date format and others are in exponential format. How
can I format the number to keep the numbers from changing format. I have
tried various formats before savint the file. In this instance, the numbers
represent part numbers and the file is being imported into my business
software to update pricing.
 
G

Gord Dibben

If you are re-opening in Excel, the behaviour you describe is typical.

Have you tried opening the *.csv file in Notepad or similar application?


Gord Dibben MS Excel MVP
 
Top