Is there a way to show different currencys i.e "£" or "$" depending on the text in a cell?

tonywatsonhelp

Well-known Member
Joined
Feb 24, 2014
Messages
2,388
Hi Everyone,

I create invoices in several currencys and I constantly have to change the formating of column J, K, & N which i can sometimes forget.
however ever company has is currency stated in cell B2 of the sheet.

so is there an easy way to format the cell to show the correct currancy?
i.e. if B2= "Dollar" then format "$" "GBP" then format "£" ?

I know I can d it with VBA but was wondering if there was a excel way as I've loads of these to set up.

any ideas would be apreciated.

Thanks

Tony
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
22,888
You could use the TEXT function and a helper column, =TEXT(J1, IF($B$2="dollar","$","£")&"#,##0.00")
 

Forum statistics

Threads
1,085,932
Messages
5,386,829
Members
402,020
Latest member
tsfan74

Some videos you may like

This Week's Hot Topics

Top