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,386
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,884
You could use the TEXT function and a helper column, =TEXT(J1, IF($B$2="dollar","$","£")&"#,##0.00")
 

Forum statistics

Threads
1,085,506
Messages
5,384,078
Members
401,881
Latest member
Dato

Some videos you may like

This Week's Hot Topics

Top