Range Question
 

I have a range of numbers. Can I subtract 96 from every number in
that range?

The range of numbers was originally found by formulas. I then copied
and paste (special-values) into another grid. Now I want to subtract
96 from each of those numbers.

Beats me if there is a way.

Thanks

Range Question
 

I posted to quick. Actually, what I really want to do is subtract 96
from the original range of numbers--the ones with the formulas.
Otherwise i'll just have to figure out a way to put the new values
back into the original grid.

There must be a way to do something to every cell in a grid.

Thanks.

On Mon, 10 Dec 2007 17:11:49 -0800, Peter
wrote:

I have a range of numbers. Can I subtract 96 from every number in
that range?

The range of numbers was originally found by formulas. I then copied
and paste (special-values) into another grid. Now I want to subtract
96 from each of those numbers.

Beats me if there is a way.

Thanks

Range Question
 

On Mon, 10 Dec 2007 17:11:49 -0800, Peter wrote:

I have a range of numbers. Can I subtract 96 from every number in
that range?

The range of numbers was originally found by formulas. I then copied
and paste (special-values) into another grid. Now I want to subtract
96 from each of those numbers.

Beats me if there is a way.

Thanks


Put 96 in some cell.

Select that cell.

Edit/Copy

Select the range from which you want to subtract 96.

Edit/Paste Special -- Subtract

If the contents of the target cell is a value, the result will be the original
value minus 96.

If the contents of the target cell is a formula, the result will be:

=(original_formula)-96


--ron

Range Question
 

Thank you so much.

On Mon, 10 Dec 2007 20:28:40 -0500, Ron Rosenfeld
wrote:

On Mon, 10 Dec 2007 17:11:49 -0800, Peter wrote:

I have a range of numbers. Can I subtract 96 from every number in
that range?

The range of numbers was originally found by formulas. I then copied
and paste (special-values) into another grid. Now I want to subtract
96 from each of those numbers.

Beats me if there is a way.

Thanks


Put 96 in some cell.

Select that cell.

Edit/Copy

Select the range from which you want to subtract 96.

Edit/Paste Special -- Subtract

If the contents of the target cell is a value, the result will be the original
value minus 96.

If the contents of the target cell is a formula, the result will be:

=(original_formula)-96


--ron