How to prevent Numbers from changing currency automatically 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.
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.)