DYnamic currency symbol
 

My XLS contains different currencies (i.e. $, £, ‚¬, ...), one per sheet. Is
there a smart way to use the same formulas and formatting forcing the dynamic
adoption of the appropriate currency symbol, an information known in each
worksheet?

As an example, when dealing with British Pounds, all financial data should
be preceded by £. Automatically a different sheet populated with US $ will
prefix financial figures by $.

Thanks, Stefano