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 ?

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 ?

I should have added that if you need to store a larger number but
not do math with it (e.g., a credit card number), precede the
number with an apostrophe. The apostrophe will not show in the
cell, but will show in the formula bar.


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