View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Irfan Khan[_2_] Irfan Khan[_2_] is offline
external usenet poster
 
Posts: 28
Default Date Formatting & Sorting

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 !!!