Pivot table date format

%3CLINGO-SUB%20id%3D%22lingo-sub-2065022%22%20slang%3D%22en-US%22%3EPivot%20table%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065022%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20you%20permanently%20change%20the%20date%20format%20in%20the%20column%20label%20of%20a%20pivot%20table%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%20picture%20attached.%20I%20can%20change%20the%20date%20format%20of%20the%20cell%2C%20but%20when%20i%20change%20the%20subject%20of%20the%20table%20(i.e.%20this%20table%20contains%20info%20about%20one%20place%2C%20and%20you%20can%20use%20the%20filter%20to%20change%20which%20place%20you%20are%20looking%20at)%2C%20it%20reverts%20back%20to%20this%20US%20date%20time%20format%20of%20mm%2Fdd%2Fyy%20tt%3Amm%3Ass%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20permanently%20change%20the%20format%20to%20dd%2Fmm%2Fyyyy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2065022%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2065378%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%20date%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065378%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F930815%22%20target%3D%22_blank%22%3E%40atrayn%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20would%20change%20the%20%3CSTRONG%3Ecalendar%20type%3C%2FSTRONG%3E%26nbsp%3Bsetting%20in%20the%20Operating%20Systems.%3C%2FP%3E%3CP%3EOpen%20%3CSTRONG%3ERegion%3C%2FSTRONG%3E%20Windows%20by%20click%20%3CSTRONG%3Ewindows%20%2B%20R%3C%2FSTRONG%3E%20on%20the%20Keyboard%20--%26gt%3B%20type%20i%3CSTRONG%3Entl.cpl%3C%2FSTRONG%3E%20--%26gt%3B%20%3CSTRONG%3EOK%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EFrom%20%3CSTRONG%3ERegion%3C%2FSTRONG%3E%20windows%20--%26gt%3B%20click%20on%20%3CSTRONG%3EAdditional%20settings%3C%2FSTRONG%3E%20--%26gt%3B%20go%20to%20%3CSTRONG%3EDate%3C%2FSTRONG%3E%20tab%20--%26gt%3B%20on%20the%20Calendar%20type%26nbsp%3B%20choose%20%3CSTRONG%3EGregorian%20Calendar%3C%2FSTRONG%3E%20--%26gt%3B%3CSTRONG%3E%20OK%20%3C%2FSTRONG%3E--%26gt%3B%3CSTRONG%3E%20OK%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22intl.png%22%20style%3D%22width%3A%20885px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246752i7D7F15BA52A43026%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22intl.png%22%20alt%3D%22intl.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E*%20If%20my%20post%20helped%20you%2C%20please%20click%20on%20like.%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 (i.e. this table contains info about one place, and you can use the filter to change which place you are looking at), it reverts back to this US date time format of mm/dd/yy tt:mm:ss

 

I would like to permanently change the format to dd/mm/yyyy

1 Reply

@atrayn 

 

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

 

intl.png

 

* If my post helped you, please click on like.