I have date range in Col A with the format say 24.01.2009 i.e.24th Jan
2009,20.03.2009, 19.02.2009,17.02.2009,16.03.2009 and so on. While I want to
sort the dates in whole range according the ascending order, it is sorted
like this:
24.01.2009
16.03.2009
17.02.2009
19.02.2009
20.03.2009
So the sorting is not done date wise. Any body can help me?

In B1 enter:
=DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)) and copy down
then sort cols A & B by B to display:

24.01.2009 1/24/2009
17.02.2009 2/17/2009
19.02.2009 2/19/2009
16.03.2009 3/16/2009
20.03.2009 3/20/2009

--
Gary''s Student - gsnu200841


"sksk4798" wrote:

I have date range in Col A with the format say 24.01.2009 i.e.24th Jan
2009,20.03.2009, 19.02.2009,17.02.2009,16.03.2009 and so on. While I want to
sort the dates in whole range according the ascending order, it is sorted
like this:
24.01.2009
16.03.2009
17.02.2009
19.02.2009
20.03.2009
So the sorting is not done date wise. Any body can help me?

Select the data.

DataText to ColumnsNextNextColumn Data FormatDMY and Finish.


Gord Dibben MS Excel MVP

On Sun, 29 Mar 2009 09:01:01 -0700, sksk4798
wrote:

I have date range in Col A with the format say 24.01.2009 i.e.24th Jan
2009,20.03.2009, 19.02.2009,17.02.2009,16.03.2009 and so on. While I want to
sort the dates in whole range according the ascending order, it is sorted
like this:
24.01.2009
16.03.2009
17.02.2009
19.02.2009
20.03.2009
So the sorting is not done date wise. Any body can help me?