Hey all,
I have an excel file with a Pivot Table. I have formatted a "date column" to custom numbers mm-dd-yyyy, and refreshed all data and sources. Yet my pivot table Filter (which is the date column from source table) continues to convert to dd-mmm or "12-Jan".
The desire is to have this display just as the source whereas it should read 01-12-2022. Please help save me from continuous research and scrounging. Your assistance is appreciated.
Scott
I have an excel file with a Pivot Table. I have formatted a "date column" to custom numbers mm-dd-yyyy, and refreshed all data and sources. Yet my pivot table Filter (which is the date column from source table) continues to convert to dd-mmm or "12-Jan".
The desire is to have this display just as the source whereas it should read 01-12-2022. Please help save me from continuous research and scrounging. Your assistance is appreciated.
Scott