Unable to get Sort to treat week days and months as TEXT string and not a date

[wadezone]

I have an Excel column with song titles in it. When I do a Pivot table and sort the data by the songs it keeps putting the song titles "Saturday" and "September" at the top with the numbers instead of down in the "S"s. I am assuming it is treating these as numbers instead of text like September is 09 or 9.

What I need is to these date reference names to be in the sort based on the text.

Below is what I am getting
SATURDAY
SEPTEMBER
02 RAIN FROM FALLING 1
03 EASE AWAY THE PAIN 1
04 RUNNING OUT ON ME 1
06 ANYTHING 4 LUV 1
07 GIVE IT TO ME 1

This is what I need.

SATAN S BREATH 1

SATURATE 6

SATURDAY

SATURDAY AT THE MALL ALT 60

SATURDAY MORNING

SATURDAY NIGHT 2

SATURDAY NIGHT 3

SAVAGE PEAK

<colgroup><col></colgroup><tbody>
</tbody>

Thanks in advance

 

[iliace]

Try this. Select the PivotTable you create, and go to PivotTable Options (either right-click on it, or under Analyze->PivotTable->Options drop-down). Move to the Totals and Filters tab, and at the bottom, uncheck "Use Custom Lists When Sorting".

See if that helps.

 

[wadezone]

iliace - PERFECT! That did it. It sorts correctly. Thank you so much. I searched the internet for hours with no luck. Adding that to my tips/treat list.

 

[iliace]

Cool, glad it worked It took me a little poking around to find that setting, too - I knew I had seen it before, but didn't know where exactly, never had it be an issue until I tried your sample data