Sorting text numbers in an excel pivot

[Peter Davison]

I have a column of regions in a pivot table (row section) It is numbered from 1 to 10. How can I get the sort to treat it as numbers so 10 is at the bottom?

Any help would be appreciated.

 

[jasonb75]

You either need to use proper numbers or use a leading 0 with the single digit numbers.

Or if it is just 1 to 10 as per your post, you could manually drag 10 to the correct position.

 

[Peter Davison]

Thankyou for your help