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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
.csv And (Possible) Spreadsheet Differences Questions 3
CSV files and having numbers and strings in there... 9
csv format 3
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Converting numbers and number formatting to a CSV file ? 1
CSV file doesn't save "xEy" style number as text formatted data 1
Formating Numbers 11

Back
Top