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"
I've had the same issue; formatting the specific dates don't display the same way in the Pivot graph. Try selecting the entire column that contains the dates in your Pivot Table (rather than the specific cells that contain the dates), and then format your date preference for the entire column.