Forum Discussion
Solved
Date Formatting in a Pivot Table
I have not been able to format dates in a Pivot Table since I started using Excel 2016. I have tried a number of fixes on the blog to no avail. The data worksheet has the date formatted as I would ...
- Hi Lorrie
Right Click on the 2-Jun and select Ungroup. That should fix it
To prevent it happening in future go to File > Options > Data and tick "Disable Automatic Grouping of dates"
Hi Lorrie
Right Click on the 2-Jun and select Ungroup. That should fix it
To prevent it happening in future go to File > Options > Data and tick "Disable Automatic Grouping of dates"
Right Click on the 2-Jun and select Ungroup. That should fix it
To prevent it happening in future go to File > Options > Data and tick "Disable Automatic Grouping of dates"
Thank you!