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" <dmcritchie_xlmvp@verizon.net> wrote in message
news:#iK7XUJGGHA.216@TK2MSFTNGP15.phx.gbl...
> 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
> > >
> > >
>
>