sorting alpha numeric list by first left digit

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

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
>
>

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
> >
> >

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
> > >
> > >
>
>