Sorting Date Ranges

Greetings,

This should be simple, really simple. However, I'm having difficulty getting this right. I've read multiple forums from basic searches. Unfortunately, none of these solutions appear to be salient to my particular problem...so I'm hoping for assistance here.

I have a column organized by the following date ranges:

1-30
30-60
60-90
90-120
120-999

I want it to look like that every-single-time. However, when I add a filter and sort it, I get this crap:

90-120
60-90
30-60
1-30
120-999

and

120-999
1-30
30-60
60-90
90-120

That's not right. And, before you ask, I did add the apostrophe prior to typing this out - so it is recognizing this as a number. I do not want to add any more columns as a means to solve this problem because this information is being used on a pivot table I'm creating. I fear that tampering with this by adding more stuff to it will only disrupt the data flow.

People, I just want it to look like this when I sort these date ranges, is that so hard?

120-999
90-120
60-90
30-60
1-30

1-30
30-60
60-90
90-120
120-999

Assistance would be greatly welcomed and appreciated!

If you already have a column which contains these ranges as the values, you can even give a try for something called Custom List. Custom list is a place where you can upload any order of your choice and you can even call that order in a pivot sorting as well.

Pardon me! if I did not get your requirement correctly.

If I got it right, check the below link where you can find how to do this process:

http://www.techrepublic.com/blog/10-...ting-in-excel/