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.
[TABLE="width: 451"]
<colgroup><col></colgroup><tbody>[TR]
[TD]SATAN S BREATH 1 [/TD]
[/TR]
[TR]
[TD]SATURATE 6 [/TD]
[/TR]
[TR]
[TD]SATURDAY [/TD]
[/TR]
[TR]
[TD]SATURDAY AT THE MALL ALT 60 [/TD]
[/TR]
[TR]
[TD]SATURDAY MORNING [/TD]
[/TR]
[TR]
[TD]SATURDAY NIGHT 2 [/TD]
[/TR]
[TR]
[TD]SATURDAY NIGHT 3 [/TD]
[/TR]
[TR]
[TD]SAVAGE PEAK [/TD]
[/TR]
</tbody>[/TABLE]


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