You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

numbers rounds where it shouldn’t

Hello


I created a Numbers file in Numbers 3.6.2 under Mac OS X 10.11.6, later opened it in Numbers 12.0 under macOS 12.4, saved it there, then saved it as Number 09 to open it on the mac running 10.11.6 again, where another conversion happened, when Numbers 3.6.2 asked me to either update the file or to work on a copy (I updated it).


After those three conversions, it turns out that in some cells, Numbers rounds some numbers (in some cells) with decimal fraction to integers (570.37 becomes 570). This happens only when the cell contains a formula, even if that formula is nothing but a referral to another cell. It does not happen when simply writing a number into that same cell.


It appears that some corruption to the original file has happened. Would anyone know if there is a way to undo that damage? The file in question is large, contains many sheets with lots of work, it would be close to impossible to set it up anew. A fix would be greatly appreciated.


Thanks!

Mac Pro, OS X 10.11

Posted on Jun 5, 2022 3:35 AM

Reply
Question marked as Top-ranking reply

Posted on Jun 5, 2022 4:30 AM

Hi Nikolai,

based on your description it is impossible to say where the issue started.


Here my recommendation, if you still have the original file:

  1. Open the original file in Numbers 12.0 and see if it is still OK
  2. Save as Numbers 09 and open it in Numbers 12.0 and see if it is OK
  3. Open in Numbers 3.6.2, open it as a copy and see if it is OK


Based on this test you will know in what conversation step the issue started.


Is it only a display issue that 570.37 is shown as 570 or is it really permanently rounded?

You can check this by changing the format of this cell to add / remove digits.


Ralf


Similar questions

2 replies
Question marked as Top-ranking reply

Jun 5, 2022 4:30 AM in response to Nikolai Franke

Hi Nikolai,

based on your description it is impossible to say where the issue started.


Here my recommendation, if you still have the original file:

  1. Open the original file in Numbers 12.0 and see if it is still OK
  2. Save as Numbers 09 and open it in Numbers 12.0 and see if it is OK
  3. Open in Numbers 3.6.2, open it as a copy and see if it is OK


Based on this test you will know in what conversation step the issue started.


Is it only a display issue that 570.37 is shown as 570 or is it really permanently rounded?

You can check this by changing the format of this cell to add / remove digits.


Ralf


numbers rounds where it shouldn’t

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.