Forum Discussion
Pivot table displays only month of full date - can't display year.
Hi. I have created a pivot table from a data set. One of the fields in the data set is a date field (and I've checked, Excel is recognising it as a date in the format mm/dd/yyyy). However, when I add this field to the rows of my pivot table, it only displays the month in text format (ie, "Feb"), and then creates a separate column with the year. I'm trying to get it to display the full date in the pivot table in a single column, not split.
Please help?
Catherine,
right-click on a month or date and select "Ungroup".
17 Replies
- holscherkcCopper Contributor
Catherine Klopper Thank you for the help on this issue!
- LionelD1685Copper Contributor
Catherine Klopper Thanks for asking the question. I was heading down to hour wasted rabbit hole and was saved by the answer to your questions. 🙂
- Detlef_LewinSilver Contributor
Catherine,
right-click on a month or date and select "Ungroup".
- Rennae_HipplerippleCopper ContributorThis was an absolute life saver! TYSM
- cltguyCopper ContributorThank you! I think I have googled this questions multiple times and your answer is simple, to the point, and correct....but I can't ever remember it 😄
- aabb11Copper Contributor
Thank you for your answer! Detlef_Lewin