subtract 10 from every number in a 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=395066

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