Hi William,

The issue is caused that Excel still thinking that the number is a number
after we format the cell as Text. And then when we sort the cells, it will
sort the numbers and the texts separately.

I performed further research and testing. Eventually, I found the solution
now. : Please refer to the following steps.

1. In the Excel file, copy the column G.
2. Open a new notepad file (click the Start menu Run type notepad,
click OK.)
3. Paste it into the new notepad file.
4. Press Ctrl + A in the new notepad file. Press Ctrl + C to copy it.
5. Go to the Excel file, select or insert a blank column (to be used for
sorting). Format the blank column as Text. Press Ctrl +V to paste the text
from Notepad to Excel. Thus, the cells are exactly Text now.
6. Try to sort it again. What is the result?

If anything is unclear or if you have any other concerns, please don't
hesitate to contact me.

Sincerely,

Emily Lin,
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====