ExcelBanter - Sort anomaly in Excel 2003 SP2 on Windows XP SP2

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort anomaly in Excel 2003 SP2 on Windows XP SP2 (https://www.excelbanter.com/excel-discussion-misc-queries/128923-sort-anomaly-excel-2003-sp2-windows-xp-sp2.html)

Sort anomaly in Excel 2003 SP2 on Windows XP SP2

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...

Sort anomaly in Excel 2003 SP2 on Windows XP SP2

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

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

andyb wrote:

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