Pivot Table Grouping by Month

In my raw data, I have field called Month and it's entered as 4/1/05
but formatted as April-05. When I use this field to group data in a
pivot table, the months appear as 4/1/05. How can I make them appear
as April-05 without having to format each individual cell in the pivot
table?

.

Relevant Pages

  • Re: Sending a Pivot Table by Mail
    ... calling the macro from the Windows Task Scheduler ... I've tried to send via every format available, ... Transfer the raw data, then convert to a pivot table in Excel. ...
    (comp.databases.ms-access)
  • Re: Sending a Pivot Table by Mail
    ... (which is not possible with the standard crosstab) ... Another option is to export the pivot table to excel from the pivot ... I've tried to send via every format available, ... file of the raw data, ...
    (comp.databases.ms-access)
  • Re: Pivot Table Grouping by Month
    ... doesn't format it very well, or copy the range into another column, format ... > In my raw data, I have field called Month and it's entered as 4/1/05 ... > but formatted as April-05. ... > pivot table, ...
    (microsoft.public.excel)
  • Re: DCOUNT problem with numbers stored as text
    ... the rows where the Code column equals 11 stored as text. ... I format such cells as numeric, but again this is not an option when I ... am programatically populating the raw data. ... Because I am using the Jet provider, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: DCOUNT problem with numbers stored as text
    ... The reason you might want to get away from the D functions is that they are ... I learned them was because the criteria is similar to the advanced filter ... am programatically populating the raw data. ... only way I have found to avoid data format errors on import is ...
    (microsoft.public.excel.worksheet.functions)