Hi Venus

Place the number you wish to subtract in a blank cell. Copy that cell.
Mark the range of existing data, Paste SpecialSubtract.

or, in a column alongside your data (supposing the data is in column A
and the value you wish to subtract is 5) then
=A1-5
Copy down the column for the extent of your data in column A.


--
Regards

Roger Govier


"venus21pam"
wrote in message
...

Hi,

I have a column of numbers and I want to substract a certain value
from
every cell in that column and create a new column with new set of
numbers.
How do I do that?

Thanks,

Venus


--
venus21pam
------------------------------------------------------------------------
venus21pam's Profile:
http://www.excelforum.com/member.php...o&userid=30368
View this thread:
http://www.excelforum.com/showthread...hreadid=500201