opening text file converts numbers to scientific notation
 

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?

opening text file converts numbers to scientific notation
 

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/ex...491511033.aspx
http://www.rondebruin.nl/0307commands.htm
http://www.computerworld.com/action/...leId=9028 218
--
David Biddulph


"Ken Clark" wrote in message
...
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?