View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Peter Ellis
 
Posts: n/a
Default Large integers in excel 2003 are rounded ?? Is this a BUG ?

I just tried it and Excel did the same thing. Looks odd. I removed all
formatting though and the number changed to scientific notation

1.81818E+15

Probably some quirk with the number being so large. You might want to
explore Microsoft's Knowlege base on this.




"Mike One" wrote:

Format a cell as number and set decimal places to 0.

Then enter 1818181818181818 in a cell and hit enter...

Excel then CHANGES to the number to:

1818181818181810 ???? WHAT ???

This can't be right can it ??, what am I missing ?