Forum Discussion

Copper Contributor

Dec 16, 2021

Pivot Table Filter for Months in Chronological Order

I have my raw data filtered chronologically by months of the year. When I create a pivot table, the months show out of chronological order. How do I get the pivot table filter drop down to display mo...

excel

Riny_van_Eekelen

Platinum Contributor

Dec 16, 2021

SaraOC Most likely the dates aren't real dates but texts that look like dates. Then they get sorted in alphabetical order. "10-O" thus get sorted before "1-J".

SaraOC
Copper Contributor
Dec 16, 2021
Riny_van_Eekelen True, but when I convert it to a date the issue remains.
- Riny_van_Eekelen
  Platinum Contributor
  Dec 16, 2021
  SaraOC But then they are still texts. What do you see when you enter a formula like =ISNUMBER(A1) where A1 would be a cell with a date?
  - SaraOC
    Copper Contributor
    Dec 17, 2021
    Riny_van_Eekelen I get "TRUE" when I type in that formula.