Jun 26 2018 02:04 AM
Hi. I have created a pivot table from a data set. One of the fields in the data set is a date field (and I've checked, Excel is recognising it as a date in the format mm/dd/yyyy). However, when I add this field to the rows of my pivot table, it only displays the month in text format (ie, "Feb"), and then creates a separate column with the year. I'm trying to get it to display the full date in the pivot table in a single column, not split.
Please help?
Jun 26 2018 03:10 AM
SolutionCatherine,
right-click on a month or date and select "Ungroup".
Jun 26 2018 03:29 AM
Apr 13 2021 07:40 AM
Should have looked here before I wasted an hour on this. Thanks
Apr 22 2021 12:27 AM
May 03 2021 08:46 PM
May 28 2021 06:43 AM
I've been fighting this for quite some time --- thank you for giving clarification!
Jun 10 2021 09:23 PM
Jul 28 2021 09:34 AM
Dec 28 2021 06:07 AM
Feb 13 2022 05:25 PM
@Catherine Klopper Thanks for asking the question. I was heading down to hour wasted rabbit hole and was saved by the answer to your questions. :)
May 24 2022 07:22 AM
@Catherine Klopper Thank you for the help on this issue!
Dec 31 2022 12:27 PM
Best and simplest solution ever. I have wrestled with this for a while and wondered why Microsoft would change the previous default format displays. Seems so counter intuitive.
Jan 29 2023 02:08 AM
Feb 13 2023 10:23 PM
May 12 2023 12:08 AM
Thank you for your answer! @Detlef Lewin
Apr 29 2024 01:28 PM
Jun 26 2018 03:10 AM
Solution