NUMBERING ROWS

C

CRUSTY

hi, i am trying to give the rows a number in a designated column that when 1
is entered and i drag down the rows the numbers following will automatically
change in order eg 1.2.3.4.5.6.7.8.9. etc

any help willbe brilliant

thanks
 
M

Max

One guess ..

Suppose the initial row number will be entered in A1, eg in A1: 1
Put in A2: =IF($A$1="","",A1+1)
Copy A2 down as far as required
 
Top