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?