Displaying dates in a pivot table.

Question

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 was fine. When I created the table in this years file problem cropped up. I tried copying P/Y's table in new file, changing source data - no joy.Sum of Deposit&nbsp;&nbsp;Column Labels&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Row Labels-500-499-498-497-496-495&nbsp;Grand Total&nbsp;Grand Total&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 353.00&nbsp; 1,820.00&nbsp; 585.00&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,758.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9-Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 135.00&nbsp;&nbsp;&nbsp;&nbsp; 500.00&nbsp; 200.00&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 835.002-Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 25.00&nbsp;&nbsp;&nbsp;&nbsp; 620.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 645.0023-Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 125.00&nbsp;&nbsp;&nbsp;&nbsp; 300.00&nbsp; 295.00&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 720.0016-Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68.00&nbsp;&nbsp;&nbsp;&nbsp; 400.00&nbsp;&nbsp;&nbsp; 90.00&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 558.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

sergeibaklan · Answer

Paul_Cardin&nbsp;
Do you have dates (e.g.&nbsp;01/09/22 formatted as dd-mmm) or texts (like "09-Jan") ?

paul_cardin · Answer

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

paul_cardin · Answer

See my reply to myself as I figured out the solutionPaul

sergeibaklan · Answer

Paul_Cardin&nbsp;, okay, thanks

Forum Discussion

Displaying dates in a pivot table.

4 Replies


9-Jan	135.00	500.00	200.00	-	-	-	835.00
2-Jan	25.00	620.00	-	-	-	-	645.00
23-Jan	125.00	300.00	295.00	-	-	-	720.00
16-Jan	68.00	400.00	90.00	-	-	-	558.00