Euro Conversion

D

Del

I get this speadsheet once a month from one of my
retailers. There are usually 300 products with 300
different prices. Is there an easy way to convert all
this to US Dollars from Euro in the spreadsheet?
 
R

Ron de Bruin

1 Euro = 1.283 USD (Babylon 1/12/2004)

Enter 1.283 in a empty cell
Copy that cell

Select the 300 cells with prices
right click on it and choose Paste Special
Check Multyply
OK
 
P

Peo Sjoblom

Get the currency rate, put it in a cell, copy it,
assuming it is something like 1.26
select the euro prices and do edit>paste special and select divide.
There are some drawbacks since there won't be any auditing trail if things
go wrong,
You might as well use a formula like

=A1/currency_rate

of course this means that the currency rate must be in dollars, if it is in
euros multiply instead
 
N

Norman Harker

Hi Del!

The conversion rate varies continuously.

Put the current conversion rate in a cell.

Copy that cell
Select the prices in US Dollars
Edit > Paste Special

Use Multiply or Divide depending upon conversion factor used.

But remember that this permanent changes your data and if you come
back later and the conversion rate has changed, it will all end in
tears if you've deleted the original multiplier and / or forgotten if
you've applied it.

I'd much rather go the way of a separate Euro column and convert the
prices in that column using a conversion facto cell.

Or at minimum I'd save the original file under a different name or
insert a new sheet with data copied to it and work on that one.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top