Yes, agreed. When I do a quick sample myself...I get the same result as
you. User just emailed me their workbook...and it will only sort this
way:

BO33
AT283
AT384
AT386
AT645
AT651
DA008
DAA&M
NY321
NY548
NY585
NY950
PH258
PH259
PH261
PH262
PH263
PH264
PH266
PH267
PH268
PH269
PH272
PH560
AT1060
AT1061

I have tried just copying this one column out of the workbook and
pasting to its own and formatting it as text to try...it just won't...


--
couriced
------------------------------------------------------------------------
couriced's Profile: http://www.excelforum.com/member.php...o&userid=26900
View this thread: http://www.excelforum.com/showthread...hreadid=475956