Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 !!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Formatting & Sorting
Select the not only date but also other columns and then go to data |
sort u can able to sort it ...... On Apr 4, 7:46*pm, 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 !!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 !!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |