Feb 04 2021 08:34 AM
Hi, all. I am putting together a simple pivot table and I am getting the Month in my date columns instead of the actual date format of 5/1/2021.
How do I tell the pivot table to give me the date format of "5/1/2021" and not "May"?
Many thanks,
Paul
Feb 04 2021 08:52 AM
@slohombre Try right-clicking on a month name and select "Ungroup".
Feb 04 2021 09:07 AM
@Riny_van_Eekelen Bingo. That worked. Thank you!
Feb 04 2021 09:17 AM
@slohombre You are welcome!