sort by year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to customize my date format? I need one with the year first
ie 2002-may-04. I want to sor t by year.


thanks
 
Hi Dean

Date cells will sort ascending or descending no matter which cell format
they have. If not then you may have a date-looking text instead of a date.

If you want a "group by year" or "sum by year" thing instead, a Pivot table
does that. (But make lots of coffee first if this is your first Pivot table
;-)

HTH. Best wishes Harald
 
Hi Dean

Set up a custom date format (Format, Cells, Category, Custom, Type ) and
enter yyyy-mmm-dd
 
Back
Top