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