Sort by date from Text format

[mekcsx]

I have a problem when I want to sort text to be a date format although I have already changed to date format. It still sort by text. For demonstrate, I have..

30/05/2013
31/04/2013
31/05/2013
30/06/2013

it gonna be..

30/05/2013
30/06/2013
31/04/2013
31/05/2013

As you can see above, It order from date like 30 to 31 first, then order month in the second priority. I don't know how to solve it. I have tried many ways. So, anyone has any idea to share about this problem. Thank you

 

[MARK858]

Assuming that your data starts in A1 then use a helper column with the formula

=DAY(A1)

dragged down and sort on the helper column but obviously you need real dates (in my calendar there are only 30 days in April).
If need be then use a second helper column with

=MONTH(A1)

.

 

[mekcsx]

Thanks MARK858,

I tried this in macro but it doesn't work.

Range("G6").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ReplaceFormat.NumberFormat = "dd/mm/yyyy;@"
Selection.Replace What:=".", Replacement:="/", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=NumberFormat = "dd/mm/yyyy;@"

 

[MARK858]

I am sorry but what relevance is a macro to try and change a number format when your question was how to do a sort? and also do a replace of a fullstop/period with a slash when your original data doesn't even have a fullstop/period???

mightily confused

Perhaps you need to ask the question again/more clearly