I am trying to come up with a solution that will change the currency value symbol depending on what the end user chooses - for example they choose USD vs EUR therefore the billing amount would be formatted as $100.00. I have looked for suggestions, as well as have tried several things myself. Does anyone know the best way to do this? I know changing the “format” of the cells is not that difficult, however we are trying to avoid having the users make any changes themselves.
Thank you for the response - yes, the user would choose the currency type in the prompt (e.g. USD, EUR) however when I have tried to create a variable that would display the proper symbol, it didn’t work. Do you know the syntax I would use? I will admit, I am a little rusty as it has been a few years since I have done a lot of report writing. Thank you so much!
(BOB member since 2005-02-24)