Number changes

While the following is not specifically related to Apple’s Numbers program, the behavior is the same as that in Microsoft Excel. Here’s a link to a discussion post on this behavior in Excel. I think you’ll find it helpful in explaining why this perceived “error” occurs and how you can work around it. I’ve tried the suggested methods in Numbers and each of them appear to be valid. I hope this helps!

https://docs.microsoft.com/en-us/office/troubleshoot/excel/last-digits-changed-to-zeros

I can't duplicate that here. Can you give more specifics, perhaps a screenshot? (shift-command-4, select area on screen, release, start a new post here and insert the screenshot from the Desktop with the icon at the bottom of the compose window that looks like "mountains").

SG

I am able to replicate this issue and it appears that, if you enter a 16-digit number, Numbers will round the last two digits up. You can prevent this by making sure the data type is set to “Automatic” or to “Text.” I seem to recall seeing documentation about this somewhere and, if I find it, I will post it as a follow-up to this thread. In the meantime, I hope this helps you. Good luck!

You could try unchecking everything in Edit > Substitutions.

SG