MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 200 Not Sorting Properly

Posted by Naomi on December 12, 2001 6:52 AM

When I sort a numbered list formatted as 'general' some of the numbers appear out of order. When I use the AutoFilter function the drop down list sorts the numbers is this weird fashion also. I reformated to 'number' and the same occurs. There does not appear to be a pattern to how it does this, because for example number 150 is listed several times; some will appear in the correct order and others will not. Retyping the data in the cell did not correct the problem. My spreadsheet is in Excel 2000. It has 24 columns with 700 records. A few blanks exist in the field I am trying to sort. Mis-sorted numbers do not appear immediately before or after the blanks. How do I correct this?

Posted by Mark W. on December 12, 2001 9:01 AM

1. Make sure that the General format is applied
to the entire list.
2. Choose the Data | Text to Columns... menu command
and press [ Finish ].
3. Re-sort your list.

Posted by Naomi on December 13, 2001 9:29 AM

Worked like a charm. Thanks a bunch.--Naomi