This works great, but what if the data can be either numbers or text?

Example:

5444
5445
5446
AXC XSLR
AXC XLLR

"Don" wrote:

Assuming the data will be entered in column B starting in B1 and the data
are numbers. Put this in cell A1 and copy down.

=IF(ISNUMBER(B1),ROW(),"")


If data are text then substatute ISTEXT for ISNUMBER

Don Pistulka

"Linda C." <Linda wrote in message
...
How can I set up the first column to automatically number each row as I go
down a list in excel?
Office 2000