Try this:
A2: =MAX($A$1:OFFSET(A2,-1,,,))+1

Copy that formula down as far as you need.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"jensenf" wrote:

Starting in cell A2 and all the way down, how do you put in a formula so the
cells are numbered automatically? 1,2,3, etc. and if you delete cell 4, for
example you can reconfigure it so it'll number it again. I tried =row()
function but when I drag the formula down, it keeps the numbers the same.