Populate currency symbol for the numbers based on their currency type [SOLVED]

[ThrottleWorks]

Hi,


I have 2 columns.


Column A, will have 3 values, GBP, EUR, USD.


Column B will have any random number.


My problem is


If cell a2 is GBP

If cell b2 is 100


then value in the cell b2 should be formatted with GBP symbol.


say £100


Is it possible, can anyone help me in this please.


P.S. - I am going through this link, will come back if I face any difficult.


http://chandoo.org/forums/topic/how-to-change-the-currency-symbol-dynamically-in-excel

 

[ThrottleWorks]

Hi,


These links are working for me, thanks.