sort date

[sksk4798]

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?

 

[Gary''s Student]

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

 

[Gord Dibben]

Select the data.

Data>Text to Columns>Next>Next>Column Data Format>DMY and Finish.


Gord Dibben MS Excel MVP