currency converter
 

Hi there
I am creating and expense report and I have included a drop list with
currencies but I would like to convert automatically a currency different
than EURO into EURO.
Could you please help me on this?
I am not very familiar with this so a help step by step will be very helpful

Thanks a lot

Just divide or multiply using the rates (depending on where you come from)
Example, you want to convert euros to dollars, today's rate is
1 euro = 1.29159 dollars

put 1.29159 in a cell (assume B2), assume A2 holds the amount of euros you
want to convert then use something like

=ROUND(A2*B2,2)

round will round it to the nearest cent

the other way around you have dollars in A2 and want to convert to euros

=ROUND(A2/B2,2)

or change the rate in B2 to

0.77435

and use the first formula

--
Regards,

Peo Sjoblom


"Francisco" wrote in message
...
Hi there
I am creating and expense report and I have included a drop list with
currencies but I would like to convert automatically a currency different
than EURO into EURO.
Could you please help me on this?
I am not very familiar with this so a help step by step will be very
helpful

Thanks a lot