Number format in CSV file
 

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.

Number format in CSV file
 

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.)

Simon wrote:

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.

--

Dave Peterson