I have a pivot table with a range of SAT scores listed and want to sort them in the order listed below. I have created a custom sort and go through the steps of sort, options, more options, and click on the custom sort but it still will not work. I've forced the data to be all text by puttin a single quote before all data. It will sort a-z and z-a by data in table but that is not what I want.

Is there a limit to the number of catagories it can sort?
Any suggestions?

GE_1500
1500-1540
1450-1490
1400-1440
1350-1390
1300-1340
1250-1290
1200-1240
1150-1190
1100-1140
1050-1090
1000-1040
950-990
900-940
850-890
800-840
750-790
700-740
650-690
600-640
550-590
500-540
450-490
NO_SCORES