Hi,

How would we/Excel recognise the diferent currencies if there is no
identifier?

10.23
10.23
10.23

One is dollars one is Euros and the other pounds!! I would be interested in
how you did it with CF

Mike

"smaruzzi" wrote:

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