Forum Discussion
atrayn
Jan 15, 2021Copper Contributor
Pivot table date format
How can you permanently change the date format in the column label of a pivot table? Example picture attached. I can change the date format of the cell, but when i change the subject of the table...
Jan 15, 2021
You would change the calendar type setting in the Operating Systems.
Open Region Windows by click windows + R on the Keyboard --> type intl.cpl --> OK
From Region windows --> click on Additional settings --> go to Date tab --> on the Calendar type choose Gregorian Calendar --> OK --> OK
* If my post helped you, please click on like.