Jul 05 2018 05:59 PM
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 like which is 06/02/18. When I add the date to the Pivot Table it pulls in the Month as a column which is not in my original data and then gives me a date column that looks like 2-Jun. I really want the date to look the way it is in the original data. Can anyone help please? I would truly appreciate it. Let me know if you need to see an example. Thank you in advance. I am sure it is something small I am missing.
Jul 05 2018 09:58 PM
SolutionJul 06 2018 09:27 AM
Wyn,
Thank you so much. That worked!! I knew it was something like that but I had no idea that it groups the dates in a Pivot Table. You have saved me many more hours of anguish.
Have a great weekend and summer!!!
Lorrie.
Jan 14 2022 12:27 AM
@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.
Jan 15 2022 12:50 AM
Sep 16 2022 11:55 AM
Jul 05 2018 09:58 PM
Solution