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!