Displaying dates in a pivot table.

[Paul_Cardin]

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  Column Labels       Row Labels-500-499-498-497-496-495 Grand Total Grand Total                    353.00  1,820.00  585.00    -      -      -         2,758.00

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

[#2]

@Paul_Cardin 

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

[#3]

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

[#4]

See my reply to myself as I figured out the solution

Paul

[#5]

@Paul_Cardin , okay, thanks