Type 10 in an empty cell; copy this cell
Select the column of data; use Edit|Paste Special-check the Delete box-OK
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"naga s chintala" <naga s wrote in
message ...
how can i subtract a single integer value from the entire column
say : i wanna subtract 10 from the entire column of numbers