Currency Conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a several spreadsheets in Euros. I want to change all the numbers to
Pounds Sterling. I have tried the Euro converter tool but that only gives the
old European currencies that became Euros. Surely there must be any easy way
for me to multiply all the numbers in the spreadsheet by the prevailing rate
of exchange, whatever it is.
 
Put the conversion rate in a cell, copy it, select the cells you want to
convert, do edit>paste special and depending on how the conversion is done
select either multiply or divide. For instance if you have 1000 euros in A1
and the conversion rate 1.6 in B1 meaning that one pound is 1.6 euros, then
divide, if you
the same amount of euros in A1 and a conversion rate of 0.625 meaning that
one euro is 0.625 pounds then multiply


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Perfect. i knew there was bound to be an easy way to do it, I just didn't
know about that 'Paste Special' trick. Also, your explination was very clear
and helpful.
 
Back
Top