Hi,
I have a spreadsheet where the user needs to input the currency symbol (i.e. USD, EUR, MXN, etc). Based upon what currency they put in the input into the cell, I am needing to format all numbers within certain cells to be the same currency. The currency will change multiple times so the currency symbol and number have to be dynamic.
Any ideas? And how I would even begin to look this excel function up in "help". I went to datapigtechnologies.com and although it skirted around formating functions- I never seem to what I needed in this instance.
Appreciate the help.
I have a spreadsheet where the user needs to input the currency symbol (i.e. USD, EUR, MXN, etc). Based upon what currency they put in the input into the cell, I am needing to format all numbers within certain cells to be the same currency. The currency will change multiple times so the currency symbol and number have to be dynamic.
Any ideas? And how I would even begin to look this excel function up in "help". I went to datapigtechnologies.com and although it skirted around formating functions- I never seem to what I needed in this instance.
Appreciate the help.