excel formulas
 

I have a set of values in column A. I want to subtract 10 from each value
using one function. is this possible?

excel formulas
 

Type 10 in a spare cell. Copy that cell.

Select all the target cells, goto EditPasteSpecial, click the Subtract
option, and OK.

Clear the cell with 10 in.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Evygirl" wrote in message
...
I have a set of values in column A. I want to subtract 10 from each value
using one function. is this possible?

excel formulas
 

thanks bob that did the trick. i'll be able to finish my assignment on time
now!

"Bob Phillips" wrote:

Type 10 in a spare cell. Copy that cell.

Select all the target cells, goto EditPasteSpecial, click the Subtract
option, and OK.

Clear the cell with 10 in.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Evygirl" wrote in message
...
I have a set of values in column A. I want to subtract 10 from each value
using one function. is this possible?