Forum Discussion
RDALE2435
May 12, 2020Copper Contributor
Date formating in a pivot table
I am having a challenge changing the date format in pivot tables. All my table seem to default to year, quarter, month; in lieu of the actual date. While there are times the prior format is useful, n...
Riny_van_Eekelen
May 13, 2020Platinum Contributor
RDALE2435 As an alternative, format the column that holds the dates in your pivot table to the date format of your desire. Then, make sure to check the box "Preserve cell formatting upon update" (as shown in the picture towards the bottom) under "PivotTable Options".
AndreyKlepikov
Oct 28, 2021Copper Contributor
No such option for mac-book version (((
Real headache.
Real headache.