csv format changes numbers

  • Thread starter Thread starter Bobbr
  • Start date Start date
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.
 
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
 
Back
Top