Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text converts to scientific | Excel Worksheet Functions | |||
large numbers as text replaced with scientific notation | Excel Discussion (Misc queries) | |||
Hex numbers displayed in scientific notation when importing text f | Excel Discussion (Misc queries) | |||
Scientific notation from a csv file | Excel Discussion (Misc queries) | |||
Long numbers show up as Scientific Notation | Excel Discussion (Misc queries) |