Apr 20 2018 11:07 AM - edited Apr 20 2018 11:08 AM
Hello, I'm working in a pivot table and whenever I add a date field it generates a Years and Quarter columns. How do I stop this from happening. I just need the date to appear in its normal format. I'm using Office 2016. Thank you.
Apr 20 2018 11:33 AM
Apr 20 2018 11:38 AM
Hi Marissa,
Please check this setting
May 22 2019 03:03 AM
I know this is an old thread, but I found another solution and this can be helpful for future reference.
If you want to change this for only this instance instead of the other reply where you change it so Excel never groups the dates again.
The simple solution is, when you have inserted the date you right click on it and select ungroup. That should do the trick.
Hope this helps!
May 22 2019 05:06 AM
Thank you so much for the information!
Sep 24 2024 03:55 AM