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?