TransWikia.com

Excel Cell Currency Picker

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.

One 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.

enter image description here

How it works:

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

enter image description here

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

enter image description here

  1. Finish with Ok.

N.B.

Repeat step 2 to 6 for other Currencies.

Situation 2:

Currency selected is USD.

enter image description here

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP