In a free cell, enter a 1 and copy it.

Select all the target cells, goto menu EditPasteSpecial and click Add, and
exit.

Then clear the cell with 1 in it.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mitch" wrote in message
...
My question is how do I add 1 (A new day) to all the rows of a certain
column?