Number format in CSV file

G

Guest

Guys,

I'm creating a CSV file containing 13-digit barcode numbers. However, when opened in Excel they display in scientific notation.

Any way I can cause Excel to load the numbers as text, or not use scientific notation, through the CSV file?

Thanks,
Simon.
 
D

Dave Peterson

If you rename your .csv file to .txt, you'll see the import wizard show up.

Then you can specify the delimiter and type of field (for each field).

(or just format that column after you've imported the .csv file.)
 

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 and Custom Fields 6
How do I stop Excel 2007 from using scientific notation? 2
Macro to import CSV file from fixed directory 1
Copy/paste number as text 1
Converting a number (17 characters) to text (Scientific Notation) 4
CSV to Excel 3
Problem with saving documents as .csv file 2
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1

Top