1

I have a spreadsheet that has cells with two currencies. USD & EUR. I have a cell that is a USD formatted cell. I now have a EUR cell that is based on a multiplication of the USD formatted cell with a specific exchange rate. Now, Numbers does not let me manually change the EUR cell to EUR: When I click "Cell" -> Data Format -> "Currency" and chose a EUR, it reverts back to USD.

I guess that Numbers is trying to "help" but quite frankly I would like it for me to let me chose the currency I want. The problem is new since Version 4.3 (5046). My spreadsheet worked flawlessly until now.

As a consequence many of my formulas are broken now since Numbers refuses to add different currencies - so this is not just cosmetic.

Thanks for your help!

0

I had the same issue in Numbers version 4.3. Setting the value of the exchange rate cell to target currency seemed to fix the issue. So, in my case I was converting USD to JPY. If the exchange rate cell was formatted as "number," Numbers would revert the cell with the multiplication result to a USD format. But if I set the exchange rate cell format to "Currency" and JPY, I am then able to also set the format of the cell with the multiplication result to JPY.

  • This is a great work-around. It works as follows: a) Create a new cell (e.g. in B3), fill it with '1', assign a very exotic currency to this field. b) Add that "*B3" to any formula you would like to change the currency on (no matching of currencies required). This multiplies times 1, so not changing the cell content but since it is a new currency in the mix the resulting cell can be assigned any currency you would like. Is this nice/elegant? No! Does it work? YES! Thanks! – SebastianR Nov 13 '17 at 16:58
0

I have a similar problem which may be related. In my case Numbers 4.3 allows me to specify the ratio of two currency cells as a number or a percentage but then immediately and automatically reverts the cell back to the currency format of one of the origin cells. I agree that Apple Developers are probably trying to 'help' (but don't realise that they don't yet have the competence to do so infallibly).

I have reported the problem via Apple's Feedback on: https://www.apple.com/feedback/numbers.html and suggest you do likewise. The more of us that report it the more likely they'll sort it. Meantime I have had to remove the currency format from my origin cells and added it to the description in the row/column headers. (Not ideal, I know.)

  • Thanks - indeed that seems to be the same/similar issue. I will report the problem, too. – SebastianR Nov 3 '17 at 19:16

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .