Thanks David.......I thought I detected some "weirdness" there, (sometimes
it worked, sometimes not), but thought it was just me......now I see
why.....

Vaya con Dios,
Chuck, CABGx3



"David McRitchie" wrote in message
...
For this and your previous answer, that is true if you format as text
before entry.

But formatting after entry does not change a number to text, nor text to
a number so changing the format would have no effect until reentered.
Reentering would remove leading zeros at least in Excel 2002.

See my previous reply for how to deal with the situation described.
There is also a link to a macro to fix numbers as formatted to text..
http://www.mvps.org/dmcritchie/excel/sorting.htm#mixed .


"CLR" wrote in message
...
Your sample data, when entered as TEXT, sorts as follows........
001
111
2
22-33
3

Vaya con Dios,
Chuck, CABGx3



"kaduna" wrote:


Thanks for the feedback.

Formatting the column as text still gives me the same sort as with a
numeric search. ie: shorter numbers are first.

Andy Davidson


--
kaduna

------------------------------------------------------------------------
kaduna's Profile:
http://www.excelforum.com/member.php...o&userid=30422
View this thread:
http://www.excelforum.com/showthread...hreadid=500921