Sort anomaly in Excel 2003 SP2 on Windows XP SP2

[Guest]

Excel 2003 appears unable to sort the word Sun correctly.

Source data:

Column a Column b
An 1
Bc 2
Df 3
Ec 4
S 5
Su 6
Sun 7
Sunn 8
Sunny 9
Sun Microsystems 10

Sorted output of Pivot table with sort ascenging on Column A selected

Sum of b
a Total
Sun 7
An 1
Bc 2
Df 3
Ec 4
S 5
Su 6
Sun Microsystems 10
Sunn 8
Sunny 9
Grand Total 55

Any suggestions welcome...

 

[Dave Peterson]

I think it's because it looks too much like an abbreviation for Sunday.

Maybe you can change your data to Sun(spacebar)?