Forum Discussion
Kurt_G85
Jan 09, 2023Copper Contributor
Sort a pivot table by dd
i have a pivot table with a large array of dates, when i sort it by dd it sorts like this: 1-10-11-12-13-14-15-16-17-18-19-2-20-21 -22. I want the normal sorting 1-2-3-4-5-6-7-8-9-10-11-12. My data...
mtarler
Jan 09, 2023Silver Contributor
It seem that your "dates" are being read as TEXT and hence that is how text is sorted.
You could highlight that column and go to DATA -> Text to Columns and see if it can re-format that column to be a number.
If that doesn't work I would suggest you add a column with a formula (both of which I know you don't want, BUT then copy the results of that formula as values only back onto the original data and delete the helper column so in the end the data set won't have any extra column or formula.
You could highlight that column and go to DATA -> Text to Columns and see if it can re-format that column to be a number.
If that doesn't work I would suggest you add a column with a formula (both of which I know you don't want, BUT then copy the results of that formula as values only back onto the original data and delete the helper column so in the end the data set won't have any extra column or formula.