Solved

Format dates

Posted on 2014-04-25
4
107 Views
Last Modified: 2014-04-28
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
Comment
Question by:Jagwarman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 8

Expert Comment

by:Naresh Patel
ID: 40021996
In cell B2 enter this formula =Value(A2) formula drop down copy column B and past to column A and sort.
Thanks
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 40021997
If your computer is configured for dd/mm/yy system then a normal sort will do just what you are looking for.
0
 
LVL 8

Accepted Solution

by:
Naresh Patel earned 500 total points
ID: 40022132
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
 
LVL 70

Expert Comment

by:Qlemo
ID: 40022187
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question