View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Is it the amount that you are referring to that needs to be converted? If so
put the conversion rate in a cell, then copy that cell.

Select all your amounts, then EditPastespecial and click Multiply.

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
oups.com...
Hi

I'm looking to find out if there is a way I convert all my amounts that
are currently in USD to another currency without having to go through
each and every cell and calculating the conversion. Specifically I
would like to convert these amounts into Swedish currency. I tried to
conversion tool built into Excel but that only really does Euro's and a
few others, but no Swedish currency. Can anyone help me?