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
 

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

CSV files and having numbers and strings in there... 9
Creating Multi Level list using Header Style 1
Page numbering with Merged Document and IF statements 1
.csv And (Possible) Spreadsheet Differences Questions 3
Word 2016 - Difficulties Learning Style Creation/Application 0
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Problem with MS Word paragraph and character styles: format getting messed up 2
CSV->Excel Data Problem 1

Top