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

If you just want to add 0.27 as a once off to all those cells
You can simply type 0.27 in any cell - select it and choose COPY

Then select C5:C455
Go to EDIT PASTE SPECIAL
From the paste section choose VALUES
From the operation section choose ADD
Then Click the OK button

George


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