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