| 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) | |||
Linear Mode
