View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Mel Arquiza
 
Posts: n/a
Default how do you add a new number to each cell in a column

Hi JCE,

Select a Cell and Type =C5+0.27 where C stands for column and 5 stands for row
drag the active cell downward to see the next row result then you may copy
the formula to other worksheets or cells buy using copy and specialpaste.
Hope this helps.

"JCE" wrote:

for instance in column c from row 5 to row 455 I want to add .27 to every
number that is already in each cell

example c5 has 9.09 already in it, I want to add .27 for a new total of 9.36

I then want to copy that formula so that it does the same thing all the way
to c455