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

Decimals refuse to change (iOS Numbers)

I tried to change the number of decimals in a cell but after I set 2 nothing happens. There are a formula-calculated number in the cell + text before the number. Thanks for any help!

iPhone 7, 13

Posted on Nov 5, 2020 7:29 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 9, 2020 12:49 AM

Hi Barnabas,


When you insert text anywhere in a cell, the whole cell becomes text and does not respond as a number.

The formula needs the ROUND function before adding the text.

Try this:

Formula in D2 =A2&" "&ROUND(B2÷C2,2)

Tested on a Mac, but this will work in iOS

Is this something similar to what you are trying to do?


Regards,

Ian.

2 replies
Question marked as Top-ranking reply

Nov 9, 2020 12:49 AM in response to barnabasfuto

Hi Barnabas,


When you insert text anywhere in a cell, the whole cell becomes text and does not respond as a number.

The formula needs the ROUND function before adding the text.

Try this:

Formula in D2 =A2&" "&ROUND(B2÷C2,2)

Tested on a Mac, but this will work in iOS

Is this something similar to what you are trying to do?


Regards,

Ian.

Decimals refuse to change (iOS Numbers)

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