Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting Dates in format "01/19/09"
How do I set my Excel to Always sort dates in the following format by Year,
Month, and Day? My current setting sorts by Month, date, and then year. For example my setting is sorting as follows: 01/19/09 02/01/08 02/17/08 etc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel to ignore "a", "an", "the" when sorting? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
Stop autoformatted dates without using "format TEXT" or ' | Excel Discussion (Misc queries) | |||
How do I count like dates in a column with format "January-05"? | Excel Worksheet Functions |