First in B1 th C100 enter a country - currency table:

fr ‚¬
gb £
us $

and in A1 something like:

=VLOOKUP(A2,B1:C10,2,FALSE) & 10

Now all we have to do is enter the country code in A2 and A1 will have the
correct symbol in front. If A2 contains gb, then A1 displays:

£10

--
Gary''s Student - gsnu200804


"smaruzzi" wrote:

Mike,

A1 contains a financial number: 10.00
B1 the country code: FR for France.

Then with the cursor on A1 I selected Conditional Formatting | New Rule |
Use a formula to select ... (the last one in the list).

The formula is the following: =$B$1="FR"
And then after pressing the Format button i selected Currency and the Euro
symbol.
I repeated the same sequence several times, one per currency.

Not easy to maintain and extend over time, but it works.

Stefano

"Mike H" wrote:

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