Re: Pivot Table Grouping by Month

What I've found to be the best method to actuall do this is to add a month
field. You can either add this by using a =MONTH(A2)&"/"&YEAR(A2), which
doesn't format it very well, or copy the range into another column, format
to mmm-yy, copy, paste into notepad, and paste back into Excel.

Hope this helps.

Sunil Jayakumar

"Faulk" <shane.faulkner@xxxxxxxxx> wrote in message
news:1113488406.460999.104860@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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?
>

www.ayyoo.com/mortgages.html


.

Relevant Pages

  • 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. ... pivot table, ... as April-05 without having to format each individual cell in the pivot ...
    (microsoft.public.excel)
  • Re: Problem formatting pivot table headers
    ... Ensure "Auto format table" is unchecked in pivot table options but "perserve ... enable selection should be turned on. ... From the Pivot toolbar, choose PivotTable>Select ... column headers did not inherit the propper cell background colors. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: pivot table formatting
    ... Position your mouse over the row of the pivot table that has all your ... "titles" for each column and format all those headers to bold. ... if you really want to avoid the end user having to "refresh" the ... worksheet tab and select "View Code", ...
    (microsoft.public.excel)
  • Re: pivot table formatting
    ... column and turning the whole column to bold. ... Position your mouse over the row of the pivot table that has all your ... "titles" for each column and format all those headers to bold. ... if you really want to avoid the end user having to "refresh" the ...
    (microsoft.public.excel)
  • Re: Average the difference between 2 times
    ... Why use notepad or even a pivot table? ... Just average the times and format the result correctly and you're done. ... Microsoft MVP - Excel ...
    (microsoft.public.excel)