I have a column that displays currency type with a 3 digit code (ie. EUR).
Based on this code, i want to automatically update the currency type in
another column. EX

COLUMN A COLUMN B
EUR 10,345.78

Does anyone know the conditinal formula that would make this possible?
Based on COLUMN A code, Column B would format the number in the right
currency?

Been struggling with this for days!