The values with a character at the end are being sorted as TEXT, not numbers.
The only way I could get it to work was to include a ' before the number.
I'm sure there's a more elegant way.

"roger_home" wrote:


My company has a 3 or 4 digit job number on all its jobs (i.e., 872,
944, 1015)...when I do a sort by number, all is fine. But occasionally
we add a A or a X to the end of the number (i.e., 772A, 1001X). Now
when I do a sort by number, these go the the bottom. Any way to keep
them in order by number?


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=385270