Maybe something like this
Assume data will be sequentially entered in B2 down
Put in A2: =IF(B2="","",ROWS($1:1))
Copy A2 down to cover the max expected extent of data entry in col B, eg
down to A100. Col A will return the serial numbering in tandem with the data
entry in col B

If above helps, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"pawnraider" wrote:
I'm trying to number cells but the way I would like to do it is in the
adjoining cell it will be the next number. Y'know like 1,2,3,4 and so on. I
have two books on Excel but I can't find that info. Thanks for the help.