subtracting a constant number to all cells in the same column
 

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?


--
gimianame
------------------------------------------------------------------------
gimianame's Profile: http://www.excelforum.com/member.php...o&userid=26203
View this thread: http://www.excelforum.com/showthread...hreadid=395067

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

"gimianame" wrote in
message ...

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?


--
gimianame
------------------------------------------------------------------------
gimianame's Profile:
http://www.excelforum.com/member.php...o&userid=26203
View this thread: http://www.excelforum.com/showthread...hreadid=395067

gimianame Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=395067