I have a table with two columns:
Column A = numbers
Column B = currency codes (i.e. USD, JPY, EUR, etc…)
how can I have cells on column A to automatically format as the correct currency based on the code column B on the same row?