Question: how to change date format in excel pivot?
Answer: Right-click a cell in the date field of the pivot table., Choose Field Settings…, Click the Number Format button., Change the Date formatting in the Format Cells window., Press OK and OK.