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