On my spread sheet the relevant account currency is entered in column B. Can
other columns be formatted to bear the currency symbol entered in column B.?
E.g if A contains USD can G show as USD100.00 when 100.00 is entered and
will it still be a numeric value?

Also, if I have three rate tables can i have a formula the looks up one of
the currency rate tables depending on the country in column A.