I have attached a simple spreadsheet as an example of what I'm trying to do. I want to be able to select a currency (dollars, yen, yuan, euro, etc.) from a drop down list and have a global macro (for the workbook) change the format for the current currency (dollars) to the selected currency. Here's the reason/logic; I have people who use my spreadsheet around the world and they are constantly asking, can I get it in my currency? So you will see in the sample I have attached.... There is an input field and a formula field and the formula is based on a % change (that requires no change in currency). So how do I automatically change the currency format to reflect the selected currency?
Thank you in advance.