Home » Questions » Computers [ Ask a new question ]

Excel 2003 Alphabetic Sort Order Is Not My Idea of Alphabetic

Excel 2003 Alphabetic Sort Order Is Not My Idea of Alphabetic

"I have an Excel 2003 spreadsheet that I'm sorting on the first column, which is formatted as Text. The sort order is strange. Here's a ""sorted"" example. I've highlighted the anomaly.
120-BDXX
120G-EDXX
120G-MEXX
120G-PRXX
120-SSXX <==== Why is 120-S after 120G-PR?
120T-03XX"

Asked by: Guest | Views: 170
Total answers/comments: 1
Guest [Entry]

It ignores the dashes.