Discussion Locked
Dynamically Changing Currencies
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'd like to know if it's possible within an Excel spreadsheet to say have a check button to select a currency option and then do a vlookup function select a cell and then display it with the appropriate currency symbol.
In other words if I select "dollar" the cells are displayed with the "$" currency symbol but if then want to use a set of Euro tables then the display cell would switch from having the "$" currency symbol to the Euro Symbol.
Thanks.