Forum Discussion
Solved
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 ...
Catherine,
right-click on a month or date and select "Ungroup".
Catherine,
right-click on a month or date and select "Ungroup".
- This was an absolute life saver! TYSM
- Thank 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 😄
Thank you for your answer! Detlef_Lewin
- thanks..solved d issue
- It was so useful 🙂
Best and simplest solution ever. I have wrestled with this for a while and wondered why Microsoft would change the previous default format displays. Seems so counter intuitive.
- This worked!
- Thanks so much!
- Thanks very much!
- Thanks!
