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!