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"
Wyn Hopkins thanks, dates now show as dd-mm-yy (after ungroup). Also, I ticked "Disable Automatic Grouping of dates", but still I can't change the format to dd/mm/yyyy for instance.
Thid did not happen with Excel 2013.