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

On Wed, 21 May 2008 07:04:01 -0700, Bobbr
wrote:

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.