Forum Discussion
Displaying dates in a pivot table.
Using EXCEL in OFFice 365, Windows 10 Computer. Row Heading is date. Format in table is 9-Jan or 16-Jan not 01/09/22 or 01/16/22 and I can't change it. The table I constructed for last year's data ...
Cancel this. I figured it out. Changed the dates in the data to number format, constructed the table, set the date format in the table to mm/dd/yy and voila 01/02/22 appeared. Changed the dates in the data back to mm/dd/yy and the pivot table appearance stayed mm/dd/yy