View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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