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