Hello,
I have a macro that performs calculations on dollar amounts. Based on the input in the first spreadsheet, the macro will produce another spreadsheet with certain prices based on previous input.
The problem is that the default currency chosen (specified through the control panel) will always override the currency specified in the spreadsheet.
For example, if the default currency is $, and I specify pounds in my spreadsheet, the macro will spit out a new spreadsheet where everything is in $ (USD). I would like to find a simple way to override the default currency specified in the control panel, so that if I type in $, the macro will produce a result with $, and if I type in pounds, the macro will produce a result with pounds.
Please let me know if this needs any further clarification.
Thanks for your help,
J.R.
Bookmarks