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


Well-known Member
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.



Some videos you may like

This Week's Hot Topics