In a free cell, enter a 1 and copy it.
Select all the target cells, goto menu Edit>PasteSpecial 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 said:
My question is how do I add 1 (A new day) to all the rows of a certain
column?