sorts not sorting

[billrebels4]

OK- Thanks to everyones help I now i have a list i can work with... but
there are a few problems.... the zips are all 5 digit and now i have to
sort them... the problem is, THEY WONT SORT CORRECTLY!!!!!!! The
numbers are not in order... some are but a lot are not... is there
anyway to fix this???? i need to sort them by zip code but cant seem to
get them to do it correctly.. any ideas???

 

[Ken Wright]

You are going to be far better off sticking to one thread, as otherwise you are going to
fragment all the replies. You have the answer to this in your other post.

 

[David McRitchie]

Hi "billrebels4" <[email protected]>,
It's hard to tell what is outstanding and not, suggest you look at
my page http://www.mvps.org/dmcritchie/excel/join.htm#fixuszip5
I just updated that section for the worksheet solutions part.

You are or should be aware that numbers sort before text, so keep
that in mind as to why you need a particular solution.