I have a spreadsheet that has cells with two currencies: USD and EUR.
I have a cell that is a USD formatted cell and the other, a EUR cell.
The EUR cell values are results of the multiplication of the USD formatted cell values with a given figure as 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 would like to have control over the currency to assign a specific cell as I used to prior to version 4.3 (5046) of Numbers.
Because most of my formulas are now broken as I can no longer make use of more than one currency.