Hi

I have a large sheet of data compiled from other spreadsheets containing
data on people. 1 column is a category column based on the number of years
each person on the sheet took to get to a particular point in their career -
anything from 2 to 29 years so the categories go from 2-3 years to 21-29
years.

I initally had a sorting problem in the sheet - the categories "10-12",
"13-15" etc were coming before "2-3", "4-5", etc! I searched through here and
found a work around - formatting them using a custom time format as hours and
minutes, the spreadsheet now sorts perfectly - "2-3" comes before "10-12" etc.

However - I ran a a pivot table to show the number in each category (in
columns) and the sort order on the pivot table (ie the order of the columns)
is "10-12", "13-15" etc and 2-3 etc comes after! Naively I assumed the pivot
would sort in the same way as the spreadsheet, using the same formatting
logic.

Any idea how I get around this please? As an aside, I've tried doing a
crosstab of this data in Crystal Reports and oddly enough, the same thing
happens with the columns...

Thanks in advance for any help.