Hi

=ROW() is the function you need and it does work! If the numbers stay the
same, make sure that calculation is set to Automatic. You'll find this
under: Tools/Options/Calculation tab

Andy.

"jensenf" wrote in message
...
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.