View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default 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