| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Long numbers show up as Scientific Notation
Hello,
We have a web based asset tracking system, and some assets have long serial numbers; for instance, 3100600300030147987 or 3101600300100020220 When we import, cut and paste, or open an HTML format page in Excel with these serial numbers, they all show up as: 3.1016E+18 and the last 6 digits get rounded up. How do we show the correct value for these long numbers in excel? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why cant you show negative numbers in parentheses? | Excel Discussion (Misc queries) | |||
| displaying numbers in engineering notation | Excel Discussion (Misc queries) | |||
| Removing Scientific Notation | New Users to Excel | |||
| convert scientific notation to a number | Excel Discussion (Misc queries) | |||
| Have negative numbers show as zero | Excel Worksheet Functions | |||
Threaded Mode
