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.

barnabasfuto Author

Level 1

8 points

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

Top-ranking reply

Yellowbox

Level 7

21,209 points

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.

View in context

Decimals refuse to change (iOS Numbers)

Similar questions