Thread: Excel Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Judy Judy is offline
external usenet poster
 
Posts: 53
Default Excel Sorting

I need to know how to sort a group of numbers that have a different amount of
digits in them and may have dashes and letters. I have tried formatting the
cells as numbers, text, and general. None of that works. It always comes up
with the 3 digit numbers first, then 4 digit, then 5 etc. I need to be able
to sort it by 1st digit, then 2nd, then 3rd, etc.

Example

112
1134-blk
112563
1290-wht
1345
150
80-17068-03