Pivot Table grouping dates

[Rscottq]

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

 

[shift-del]

Hi Scott

Right-click on a date and ungroup the date field.

 

[Rscottq]

Hi Scott

Right-click on a date and ungroup the date field.

It isn't grouped. I checked the source table and pivot table. Also, I've looked at alot of answers and I'm not even getting the standard results of right clicking a certain field as I've seen in the answers.

 

[shift-del]

The date field is in the rows or columns area?

 

[Rscottq]

It is my Filter on the Pivot Table. The source table is a list of candidates that have specified appointment dates. We will have multiple people on the same date. Then we are trying to use the pivot table to make a report from that data for a selected date. And the demand for that report is that it be in Portrait orientation with as few pages as possible. Because of that, we cannot use the sort feature directly on the source table.

Our source table is not that complex, and is the only existence for the workbook to begin with. It goes; date, name & #, Reference 1, reference 2, reference 3, reference 4, reference 5. That's it.

Thanks again for the help.

 

[shift-del]

Then move the date field into rows or column, ungroup, move it back into the filter.

 

[Rscottq]

Then move the date field into rows or column, ungroup, move it back into the filter.

That DID IT! Thanks so much!