locked
dates won't sort in my PivotTable because excel believes they are text RRS feed

  • Question

  • I can't get my dates to sort in my PivotTable because excel believes they are text. When I try to use the "text to columns" button I get an error message that the changes can't be made because it will affect the PivotTable. Any help is appreciated . 

    Thanks

    Thursday, April 23, 2020 3:07 AM

Answers

  • You can change the data type of the column in the PowerPivot table design.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, April 23, 2020 7:19 AM

All replies