Hi
you have to get the exchange rate into one field
e.g. A1 stores 1.20 (that is 1EUR = 1.20$)
if B1 stores your dollar value use the following formula in C1
=B1*(1/A1)

--
Regards
Frank Kabel
Frankfurt, Germany


Rambo wrote:
what is the formula for tranlate dollars or ponds in euro`s?

sorry for the tekst