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

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