Super User Asked by RandomExcelQ on February 15, 2021
I want to show the currency symbol (as format not text or concat prefix) in a cell which is set as a defaulted "AUD" currency so it’ll look like "AUD 1,450,000.00" but have that same cell also have a drop down option to change it’s format to other currencies. I understand one could simply format that cell and change the currency symbol but I’m looking for neat option to have it all available in a drop down for the technically challenged.
End goal: User enters a number, it shows as "AUD xxx.xx" as default. If that number should be USD, they simply enter the number as usualy then hit the drop-down and select USD which changes it to "USD xxx.xx".
This is more for a dash-boarding project. I could have just put the currency in one column and the number in the next column but that’s not my aim here as I don’t need these numbers for summing/analytics/formula working.
Thanks in advance.
I would you like to suggest the most easiest way,, the Conditional Formatting method, to change the currency symbol, based on the Drop Down.
Situation 1:
Currency selected is Rs.
How it works:
Conditional Format
, then New Rule
.N.B.
Repeat step 2 to 6 for other Currencies.
Situation 2:
Currency selected is USD.
Another method is VBA Macro,, if you are comfortable with it, replay through comments.
Adjust cell references, and currency for Drop down as needed.
Answered by Rajesh S on February 15, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP