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.

Signature
Bob
Gord Dibben - 22 May 2008 00:39 GMT
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
>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.