I have following list in Excel:
54
6A
34
5T
4X
67

When a do Data|Sort|Ascending the list looks like this:
34
54
67
4X
5T
6A

I need the list to sort like this:
34
4X
54
5T
67
6A

I have tried a half dozen ways to sort including formatting the cells,
but nothing is working. Any help would be great. Thanks.


--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959
View this thread: http://www.excelforum.com/showthread...hreadid=506446