A track several financial data re to different European markets, hence with
multiple currencies. I would like to display numbers with the appropriate
currency, a information stored in cell A1.

Is there a smart way to dynamically display number preceded by the
corresponding currency symbol so that each figure is clearly understandable?
I have found a solution thru conditional formatting, but not particularly
efficient.

Thanks, Stefano