| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why does excel turn numbers larger than 15 digits to zero?
When I type any number into excel that is greater than 15 digits, it turns
all the remaining numbers to zero. For instance, if I enter 4444555566667777 excel throws it into scientific format. When I turn it back to a number the number is now 4444555566667770. Any Idea why this is, and how I can make it stop? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep Excel from dropping my numbers to 0 after 15 digits | Setting up and Configuration of Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Mistery digits on excel | Excel Discussion (Misc queries) | |||
| excel floating digits error | Excel Discussion (Misc queries) | |||
| Excel won't sort numbers correctly | Excel Discussion (Misc queries) | |||
Threaded Mode
