View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aaron Aaron is offline
external usenet poster
 
Posts: 287
Default 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?