I have a budget spreadsheet that is currently formatted for dollars.
I set the cells with rates that we use to check a field. If that field says "US" it uses the base rate which is in US dollars if it says "EURO" it multiplies it by the conversion rate for euros.
Each cell is formatted for US Dollars with the US dollar symbol displayed, but if I set that field to "EURO" I want it to apply the rate and also display the euro symbol instead of the dollar symbol. Any idea on how to do this?