Data assumed to be in column A

In B1 enter =MID(A1,3,2)

Copy down.

Sort A and B on column B

Select "Sort anything that looks like a number as a number"


Gord Dibben MS Excel MVP

On Fri, 11 Dec 2009 15:55:01 -0800, DoxieLvr
wrote:

Is there a way in Excel to set up a sort so that the sort is done by digit?

The following list of numbers
2024
2032
2008
2016
20008
2020
20020
20032
2012

when sorted ascending would typically appear sort like this
2008
2012
2016
2020
2024
2032
20008
20020
20032

The desired sort is this
20008
20020
20032
2008
2012
2016
2020
2024
2032


Help!!!!