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.

📢 Newsroom Update

Apple introduces powerful new iPad mini built for Apple Intelligence. Learn more >

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

20,975 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