subtract a column by a number

Q

quickcur

I have a excel sheet,


Name Salary

Tony 1000
JOhn 2000
Gary 3000


I want to subtract all numbers in column "salary" by 10. So that

Name Salary

Tony 990
JOhn 1990
Gary 2990

How can I do it?

Thanks,

qq
 
T

Trevor Shuttleworth

Put 10 in a "free", that is, empty cell somewhere. Copy that cell. Select
the cells that you want to adjust. Then select Edit | PasteSpecial and use
Operation = Subtract.

Regards

Trevor
 
B

Bill Sharpe

The workers would be happier if you used Operation=Add. <g>

Bill

Put 10 in a "free", that is, empty cell somewhere. Copy that cell.
Select
the cells that you want to adjust. Then select Edit | PasteSpecial and
use
Operation = Subtract.

Regards

Trevor
 
Top