Hi,

Not clear about what you want but I assume you want a continuous range of
numbers. Try this formula =IF(ISERROR(B4+1),1,B4+1). B4 has the heading of
the numbers column. Now even after sorting, the numbers would remain 1,2,3

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Big Rich" <Big wrote in message
...
I am importing a list based on numbers (jerseys) and when I sort by the
numbers my list comes up like this:
1 Smith, John Martinsvile, IN
10 Jones, Shelly Chicago, IL
11 Martin, Tom St. Petersburg
2 Jelcin, Jeff Grand Rapids, MI
21 Bryant, Kobe Walla, Walla

How do I get them to be 1, 2, 3 and not 1, 10, 11, 2, 21?