Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 !!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting with Formatting | Excel Discussion (Misc queries) | |||
How do I keep my row formatting when sorting data? | Excel Discussion (Misc queries) | |||
Formatting Date for Sorting | Excel Discussion (Misc queries) | |||
sorting rows based upon formatting | Excel Discussion (Misc queries) | |||
Sorting by date when the date isn't exact | Excel Discussion (Misc queries) |