Put 10 in a cell and copy it.
Select all of the target cells
Menu EditPastespecial and click Subtract in the Operation area
OK
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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=395066