Currency Conversion

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)


<Heather.Lovering@gmail.com> wrote in message
news:1123529435.012434.122160@g14g2000cwa.googlegroups.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?
>

Is there a way to do this so that when you are adding up different
cells, it does not apply the currency converstion to them, or would u
have to do it section by section?

Heather,

If you want to keep the original currency and convert the sum, just use

=SUM(A1:A100)*the_rate

--

HTH

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


"Heather" <Heather.Lovering@gmail.com> wrote in message
news:1123616347.657578.175370@z14g2000cwz.googlegroups.com...
> Is there a way to do this so that when you are adding up different
> cells, it does not apply the currency converstion to them, or would u
> have to do it section by section?
>

What my co-working is trying to do is convert a whole budget
spreadsheet into a new currency. The formulas and solutions you have
given me so far are working but what they want to know is if they can
just highlight all the number columns and do the copy, pastespecial
solution - when theydo this, it does convert everything but any
summations or anything like that, gets converted twice because they are
adding up the column that is already converted and then converting that
answer - so its actually getting converted twice! Any ideas, or is this
just not possible -- I don't think it is.

thanks for all your help thus far.

Heather,

It seems to me that just do one or the other, convert the raw data or
convert the sum.

--

HTH

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


"Heather" <Heather.Lovering@gmail.com> wrote in message
news:1123701057.274335.163250@o13g2000cwo.googlegroups.com...
> What my co-working is trying to do is convert a whole budget
> spreadsheet into a new currency. The formulas and solutions you have
> given me so far are working but what they want to know is if they can
> just highlight all the number columns and do the copy, pastespecial
> solution - when theydo this, it does convert everything but any
> summations or anything like that, gets converted twice because they are
> adding up the column that is already converted and then converting that
> answer - so its actually getting converted twice! Any ideas, or is this
> just not possible -- I don't think it is.
>
> thanks for all your help thus far.
>

Here's an approach:
1) Create a copy of the sheet from which you want the currency conversion.
2) In a convenient place in that sheet, put the coversion rate (and name it
"ConRate")
3) (Now the hard work) In the new sheet, go to each input cell and change it
so it multiplies the cell in the original sheet by the conversion rate e.g.
for the cell C4 you might insert the formula "=OriginalSheet!C4*ConRate"
4) Test your work by using a ConRate of 1
5) Now, whenever there's a change in the currency values you can update your
results.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

<Heather.Lovering@gmail.com> wrote in message
news:1123529435.012434.122160@g14g2000cwa.googlegroups.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?
>

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?

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)


<Heather.Lovering@gmail.com> wrote in message
news:1123529435.012434.122160@g14g2000cwa.googlegroups.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?
>

Is there a way to do this so that when you are adding up different
cells, it does not apply the currency converstion to them, or would u
have to do it section by section?

Heather,

If you want to keep the original currency and convert the sum, just use

=SUM(A1:A100)*the_rate

--

HTH

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


"Heather" <Heather.Lovering@gmail.com> wrote in message
news:1123616347.657578.175370@z14g2000cwz.googlegroups.com...
> Is there a way to do this so that when you are adding up different
> cells, it does not apply the currency converstion to them, or would u
> have to do it section by section?
>

What my co-working is trying to do is convert a whole budget
spreadsheet into a new currency. The formulas and solutions you have
given me so far are working but what they want to know is if they can
just highlight all the number columns and do the copy, pastespecial
solution - when theydo this, it does convert everything but any
summations or anything like that, gets converted twice because they are
adding up the column that is already converted and then converting that
answer - so its actually getting converted twice! Any ideas, or is this
just not possible -- I don't think it is.

thanks for all your help thus far.

Heather,

It seems to me that just do one or the other, convert the raw data or
convert the sum.

--

HTH

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


"Heather" <Heather.Lovering@gmail.com> wrote in message
news:1123701057.274335.163250@o13g2000cwo.googlegroups.com...
> What my co-working is trying to do is convert a whole budget
> spreadsheet into a new currency. The formulas and solutions you have
> given me so far are working but what they want to know is if they can
> just highlight all the number columns and do the copy, pastespecial
> solution - when theydo this, it does convert everything but any
> summations or anything like that, gets converted twice because they are
> adding up the column that is already converted and then converting that
> answer - so its actually getting converted twice! Any ideas, or is this
> just not possible -- I don't think it is.
>
> thanks for all your help thus far.
>

Here's an approach:
1) Create a copy of the sheet from which you want the currency conversion.
2) In a convenient place in that sheet, put the coversion rate (and name it
"ConRate")
3) (Now the hard work) In the new sheet, go to each input cell and change it
so it multiplies the cell in the original sheet by the conversion rate e.g.
for the cell C4 you might insert the formula "=OriginalSheet!C4*ConRate"
4) Test your work by using a ConRate of 1
5) Now, whenever there's a change in the currency values you can update your
results.
--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

<Heather.Lovering@gmail.com> wrote in message
news:1123529435.012434.122160@g14g2000cwa.googlegroups.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?
>