Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date formating for sorting
I have a genealogy data sheet and one column contains dates. I have
formatted the column various different ways showing month/day/year, etc. If it is possible, I want to sort the column by year first, then month & day. Is that do-able? Thanks in advance. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date formating for sorting
That's the way dates should be sorted. Maybe your data isn't really dates????
Or maybe you just need to specify ascending or descending???? - Butch wrote: I have a genealogy data sheet and one column contains dates. I have formatted the column various different ways showing month/day/year, etc. If it is possible, I want to sort the column by year first, then month & day. Is that do-able? Thanks in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formating a date | Excel Discussion (Misc queries) | |||
Suggestion : Auto fill , Formating and Sorting of Tabs | Excel Discussion (Misc queries) | |||
Date Formating | Excel Worksheet Functions | |||
Date formating | Excel Discussion (Misc queries) | |||
does cell formating move with sorting | Excel Discussion (Misc queries) |