Date Formatting & Sorting
Some dates are text and others are dates.
If your Windows short date setting is mm/dd/yyyy then 13/1/1995 is an invalid
date since there is no month 13
If you format the column to General, which dates turn into a 5-digit serial
number?
These are real dates.
I would select the not real dates and DataText to ColumnsNextNexrColumn Data
FormatDate. Choosee MDY or DMY and Finish.
Gord Dibben MS Excel MVP
On Fri, 4 Apr 2008 07:46:01 -0700, Irfan Khan
wrote:
Hi All,
I am having a serious issue - i have entered date values to column and now i
want to sort them on the basis of dates only. Problem is some are getting
sorted but not all the rows. Data is as follows -
4/9/2003
5/12/2003
5/12/2003
8/12/2003
10/10/2003
10/10/2003
10/10/2003
10/10/2003
10/10/2003
10/10/2003
11/6/2003
7/1/2004
13/1/1995
13/1/1995
13/1/95
13/10/1993
13/5/1990
13/7/2001
13/9/1992
14/9/1994
15/11/1994
15/12/2003
Can somebody please tell me why their is difference yet data is enetred in
same manner only... for further clarification u can copy the data to excel.
Data should be in DD-MM-YYYY
Cheers !!!
|