Numbers is automatically formatting my cells

Whats happening is that I have a cell that is a currency and I am dividing it by a number to get a percentage. It's giving me the percentage as currency but won't let me format it back to percentage. I've switched it to auto and off and back again and then number then percentage and it would change it back to currency then I would change it to number. It was all fine and dandy yesterday I don't know if I edited something wrong or if the update has something to due with this, but I'm getting pretty annoyed with it.

Any help would/will be appreciated 🙂

null-OTHER, macOS Sierra (10.12.3), Numbers

Posted on Sep 20, 2017 3:08 PM

Top-ranking reply

SGIII

Level 8

37,550 points

Posted on Sep 21, 2017 6:58 AM

jamiefree wrote:

Whats happening is that I have a cell that is a currency and I am dividing it by a number to get a percentage. It's giving me the percentage as currency but won't let me format it back to percentage.

If you divide $100 by, say, the number 500, wouldn't you expect $0.20, not a percentage? That's what Numbers gives you.

If you divide $100 by $500 then Numbers knows you might be looking for a percentage and allows you to format the cell as a Percentage, Number, or Currency.

So if you want Percentage you can just format the divisor as Currency.

View in context

61 replies

s14kev

Level 1

4 points

Sep 21, 2017 9:33 PM in response to jordoapp

Try moving the “)” to right after the first reference rather than wrapping the whole thing in parentheses.

For example, =VALUE(“currency”) * “non-currency”

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 is automatically formatting my cells