One way...

Assuming you want column A to number as you enter data in column B.

Enter this formula in A2 and copy down far enough to account for future data
addition in column B.

=IF(B2="","",COUNTA(B$2:B2))

--
Biff
Microsoft Excel MVP


"Botkinmama" wrote in message
...
am making a form for signing up items. Need to number column cells (1, 2,
3...) without having to do it manually. Is there a function that will do
it
for me?