View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default Pivot Table Month Order

The problem is you are using month names, which Excel, naturally sorts into
alphabetical order. Your choices a

1. Use month numbers -- at least they will sort properly.
2. Use the full date, which you can format to display just the month name.
You the display that you want. and your results will be sorted properly.

Regards,
Fred

"drangonfly2664" wrote in message
...
The month order as a column heading is in the correct order except that
Sep
is at the very end rather than after Aug. I'm new at working with pivot
tables and have been unsuccessful in researching and correcting the
problem.

Thanks.