One possibility is that some of your entries may be text and some numbers?
Check with ISTEXT() and ISNUMBER().

Also, if you have two columns, are you sorting by both columns, and if so,
in what priority order, and what are the corresponding entries in the other
column if that is influencing the sorting?
--
David Biddulph

wrote in message
ups.com...
I am sorting a two columns of three digit numbers. In the second
column, 000 is sorting after 999. Anybody know what I'm doing wrong?
Thanks!