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.
Best Answer
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.