Number changes
Numbers document: I enter a number into a cell and when I click on another cell, the number I entered changes. What do I need to do fix this? It happens in any cell.
iPad, iPadOS 14
Newsroom Update
New features come to Apple services this fall. Learn more >
New features come to Apple services this fall. Learn more >
Numbers document: I enter a number into a cell and when I click on another cell, the number I entered changes. What do I need to do fix this? It happens in any cell.
iPad, iPadOS 14
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
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
I would do a screenshot but it is of my credit card number. Every time I enter that number, the last two digits automatically change. But if I enter a number that is shorter, no problem.
Number changes