Excel Cell Currency Picker

Question

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.

Rajesh S · Answer

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:

Create Drop Down in cell M18, and add the required Currency as Text
(Check Screen Shot).
Select required range.
Reach to Conditional Format, then New Rule.

Enter formula `=$M$18= "Rs".
Hit Format and select the related Currency from the list.

Finish with Ok.

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.

Excel Cell Currency Picker

One Answer

Add your own answers!

Ask a Question