subtracting in excel

[cc07]

I have a collum of numbers (going down vertically) and i want to subtract 4.4 from each number. How do i go about doing this?
Thanks

[davidthegolfer]

Assuming that your column of numbers are not formulae.

You could create a temporary helper column to the right that contains
=a1-4.4 [where a1 is the first data cell] and copy this down the entire column/data length. Then copy this helper column, and Paste Range Value back to the original column of data. You could then delete the helper column.

Do take a backup of your file before doing this, just in case.

Hope this is what you meant.
David

[arthurbr]

Enetr 4.4 in a cell somwehere
Copy it
Select the range you want to substract from
Right-click
Select " Paste Special"
Under " Operation" select " substract"
OK
That's it