subtracting a constant number to all cells in the same column

[gimianame]

I am new to excel and I am trying to use it for inventory management. I
am trying to subtract 10 dollars from every number in my Price column,
what steps would I take to achieve this?

 

[Paul B]

gimianame, put 10 in a cell, select that cell and copy it, then edit paste
special and check subtract, OK
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[BenjieLop]

I am new to excel and I am trying to use it for inventory management. I
am trying to subtract 10 dollars from every number in my Price column,
what steps would I take to achieve this?

In an empty cell that you are not using, enter 10.

Copy the cell where you entered the number 10 (Ctrl-C)

Highlight the entries in your Price column

Go to Edit/Paste Special

Click on "Subtract"

Click "OK"


Hope this is what you are looking for.

Regards.