Sorting Numbers as Text in Pivot Table
More on that.
I figured out two formulas that, when sorted along with the number,
gives me the order I need.
If I first sort on the Int of the number, then the Len of the number,
and then the number itself, they come out in the correct order. But now
what? How do I incorporate that algorithm into the pivot table?
tod
|