View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gimpy815 Gimpy815 is offline
external usenet poster
 
Posts: 5
Default sort by month on pivot report

I have a pivot report where customers are listed alphabetically in rows, and
the columns are sorted alphabetically, too. Trouble is, the columns are
months, and I want to sort Jan, Feb, etc, but it's sorting alphabeticcally.
The column headings come from a datamart list and are : Apr 05, Aug 05, and
so on on. Is it the "05" that won't let me sort by month? Any work arounds?