Forum Discussion

Paul_Cardin's avatar
Paul_Cardin
Copper Contributor
Jan 10, 2022

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 ...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 10, 2022

Paul_Cardin 

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

  • Paul_Cardin's avatar
    Paul_Cardin
    Copper Contributor
    Jan 10, 2022
    See my reply to myself as I figured out the solution

    Paul