View Single Post
  #3   Report Post  
BenjieLop
 
Posts: n/a
Default


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