View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default correct order of months in pivot table

Have you created the pivot table? If your column of data has only dates in it,
Excel should automatically group them by months. What part of the pivot table
are you having problems with?

--
Regards,
Fred


"Rocky" wrote in message
...
My worksheet has dates in the "mmddyyyy" format with associated counts of
procedures. I would like to present this in a pivot table with the counts
broken down by months and formatted as "Jan, Feb, etc."
How to do it?
Tx
Rocky