Forum Discussion
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...
The box is checked and my dates are still not showing correctly.
Date format of my date = Short Date - 12/31/2021
Pivot format - 31-Dec
Date format of my date = Short Date - 12/31/2021
Pivot format - 31-Dec
if you UNCHECK "preserve cell formatting" PivotTable takes format assigned to the field. How to set format depends on did you add data to data model creating PivotTable or not.
If not, Field Settings->Number format->select proper date format or set it in Custom
If with data model, open it in Power Pivot and format date field from menu.
If "preserve cell format" checked it shall take format applied to the cells in the grid.
SergeiBaklan What is theis regarding? I have no idea what we are talking about so please provide some insight.
