Converting to dollers, and euros

[adn4n]

Hi everyone, does anyone have any idea how i can convert all my figure
(£'s) on a worksheet, to either suit the user is they want to have th
£ figures converted to dollars(US) or euros(€) what would be th
easiest and fastest way to do this? Any ideas(???)

basically i would allow for pay in Euros, Dollars(US) or Pounds. A dro
down list would be good. Regards

 

[AlfD]

Hi!

If you put a multiplier (the conversion rate) in with every mone
amount (e.g. *$A$1) you can then fix the value of $A$1 as you want an
all other monies will follow suit.

Set $A$1 using a dropdown list by all means.

Bit more tricky (at least for me) to put in currency symbols. I would
as of now, chicken out and put in headings which mimicked the currenc
name or symbol.

I wonder if it can be formatted within the cell dynamically withou
using VBA?

Al