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" <CLR@discussions.microsoft.com> wrote in message news:8FF10ABA-1C2A-4C1C-A240-575CCE978CDC@microsoft.com...
> 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
> >
> >