Gary''s wrote on Sat, 13 Sep 2008 07:21:00 -0700:

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

--


Admittedly, it's a bit redundant but why not use the standard
abbreviations: EUR, GBP, USD etc? What's an "fr" anyway? You could also
probably autocorrect them tho I don't know if that works in a numerical
format.


Email, with obvious alterations: not.jim.silverton.at.verizon.not