Mike,

Excel, like nearly all other computer programs, use
industry-standard Double-Precision Floating Point numbers, which
are limited to 15 places of precision. Thus, you can't accurately
store larger numbers or numbers with more decimal places. See
www.cpearson.com/excel/rounding.htm for more details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Mike One" <Mike wrote in message
...
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 ?