Pivot Table Month abbreviations

[Dendrinos2]

<HR style="COLOR: #ffffff; BACKGROUND-COLOR: #ffffff" SIZE=1> <!-- / icon and title --><!-- message -->
Is it possible to display month using their "long" form instead of abbreviation? When I group data by month in a PivotTable, I only get "Jan", "Feb", etc. I would prefer "January", "February", etc. I know you can retype each month name but I wonder if there is some mysterious option hidden somewhere.

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=590440

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).