Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 110
  • Last Modified:

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
0
Jagwarman
Asked:
Jagwarman
  • 2
1 Solution
 
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
 
Naresh PatelTraderCommented:
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
 
QlemoC++ DeveloperCommented:
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now