Format dates

Can an expert assist with the formatting of the dates in the attached file please.

I need to be able to sort the dates so that they will sort
01/01/2012
02/01/2012
etc etc
01/02/2012
02/02/2012
etc etc
01/03/2013
02/03/2012
etc etc

Thanks
Dates-HELP-please.xlsx
JagwarmanAsked:
Who is Participating?
 
Naresh PatelConnect With a Mentor TraderCommented:
some modification -  insert this formula in B2 =TEXT(A2,"DD-MM-YY")
Formula Drop Down.
Copy Column B & past to Column A.
Sort.

Thanks
0
 
Naresh PatelTraderCommented:
In cell B2 enter this formula =Value(A2) formula drop down copy column B and past to column A and sort.
Thanks
0
 
Saqib Husain, SyedEngineerCommented:
If your computer is configured for dd/mm/yy system then a normal sort will do just what you are looking for.
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
The raw XML shows the dates are in dd-mm-yyyy format, which shouldn't be an issue in any locale, so we can assume the internal representation is converted correctly into "date".

The question is: how is your system configured? If it is mm/dd/yyyy, which is default for US and many other countries, you need to format them differently for displaying. Sort just works.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.