Global Calculation ???
 

Using Excel 97

I have a number of spreadsheets where I have to do a convert all amounts
with a calculation. Is there a global way to do this. There's quite a few
cells and spreadsheets ... would be nice to not have to tell each cell to do
this. (even using the fill function would be onerous).

Thanks a bunch for any short-cuts.
Diana

Global Calculation ???
 

Hi

Do you want to apply the same formula to these cells, or what? You can make
use of a macro to achieve your goal, but the macro itself will be difficult
to write without any guidelines?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Cowtoon" wrote:

Using Excel 97

I have a number of spreadsheets where I have to do a convert all amounts
with a calculation. Is there a global way to do this. There's quite a few
cells and spreadsheets ... would be nice to not have to tell each cell to do
this. (even using the fill function would be onerous).

Thanks a bunch for any short-cuts.
Diana

Global Calculation ???
 

Thanks for responding Kassie.
Fortunately, yes ... it is the same for all. It's a conversion for all
values from $C to $US (if that helps).

It would be great if this can be with less steps that what I described in my
original post
Diana.

"Kassie" wrote:

Hi

Do you want to apply the same formula to these cells, or what? You can make
use of a macro to achieve your goal, but the macro itself will be difficult
to write without any guidelines?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Cowtoon" wrote:

Using Excel 97

I have a number of spreadsheets where I have to do a convert all amounts
with a calculation. Is there a global way to do this. There's quite a few
cells and spreadsheets ... would be nice to not have to tell each cell to do
this. (even using the fill function would be onerous).

Thanks a bunch for any short-cuts.
Diana

Global Calculation ???
 

Put the rate in an empty cell (today's rate is 0.849894), copy it and select
all values,
do editpaste special and select multiply. I would probably make a copy of
your worksheet first just in case you make a typo

--
Regards,

Peo Sjoblom

(No private emails please)


"Cowtoon" wrote in message
...
Thanks for responding Kassie.
Fortunately, yes ... it is the same for all. It's a conversion for all
values from $C to $US (if that helps).

It would be great if this can be with less steps that what I described in
my
original post
Diana.

"Kassie" wrote:

Hi

Do you want to apply the same formula to these cells, or what? You can
make
use of a macro to achieve your goal, but the macro itself will be
difficult
to write without any guidelines?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Cowtoon" wrote:

Using Excel 97

I have a number of spreadsheets where I have to do a convert all
amounts
with a calculation. Is there a global way to do this. There's quite a
few
cells and spreadsheets ... would be nice to not have to tell each cell
to do
this. (even using the fill function would be onerous).

Thanks a bunch for any short-cuts.
Diana

Global Calculation ???
 

Thank you so much Peo. I appreciate the response.
This will save me tons of time.
Diana

"Peo Sjoblom" wrote:

Put the rate in an empty cell (today's rate is 0.849894), copy it and select
all values,
do editpaste special and select multiply. I would probably make a copy of
your worksheet first just in case you make a typo

--
Regards,

Peo Sjoblom

(No private emails please)


"Cowtoon" wrote in message
...
Thanks for responding Kassie.
Fortunately, yes ... it is the same for all. It's a conversion for all
values from $C to $US (if that helps).

It would be great if this can be with less steps that what I described in
my
original post
Diana.

"Kassie" wrote:

Hi

Do you want to apply the same formula to these cells, or what? You can
make
use of a macro to achieve your goal, but the macro itself will be
difficult
to write without any guidelines?
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Cowtoon" wrote:

Using Excel 97

I have a number of spreadsheets where I have to do a convert all
amounts
with a calculation. Is there a global way to do this. There's quite a
few
cells and spreadsheets ... would be nice to not have to tell each cell
to do
this. (even using the fill function would be onerous).

Thanks a bunch for any short-cuts.
Diana