opening text file converts numbers to scientific notation

[Ken Clark]

If I open a text file containing 13-digit barcode numbers for stock using
Excel 2007, the numbers are converted to scientific notation. I don't have
the option to specifiy that I want 13 digits with no decimals, but I believe
this was possible in earlier versions. Is there a workaround or a preference
i am missing?

 

[David Biddulph]

On the "Home" tab in the "Cells" group, "Format", then "Format Cells",
"Number" tab, "Number", zero decimal places.

Some hints on 2003 to 2007 command mapping:
http://office.microsoft.com/en-us/excel/HA101491511033.aspx
http://www.rondebruin.nl/0307commands.htm
http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9028218