I find this ridiculous and a bug. It will really screw up your excel sheet
when you are using CC numbers (which I found the issue with). I'm currently
using the 'quote' workaround but I can't believe a spreadsheet programme
would just do this without warning. Microsoft - BAD DOG!

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