If you have imorted this may be column with numbers (assume it is Col A) is
in text format. Try this out

--Copy a blank cell
--Keeping the copy select Column A
--Right clickPasteSpecialselect AddClick OK
--This will convert the data to numerics. Now try sort...

If this post helps click Yes
---------------
Jacob Skaria


"Big Rich" wrote:

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?