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 Edit>Pastespecial and click Multiply.
--
HTH
RP
(remove nothere from the email address if mailing direct)
<[email protected]> wrote in message
news:[email protected]...
> 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?
>
Bookmarks