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 03:35 AM

Reply
Question marked as Top-ranking reply

Posted on Jun 5, 2022 04: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 04: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


This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.