no can do.
100a is not a number as excel sees it. it's text
excel sort numbers and text differently and when sorted
togeather, number first, text last.
built in. hard coded.
if you set all of your other numbers to text, you might
get the sort you are after. otherwise you might have to
use a helper column.
good luck
HDR
-----Original Message-----
I would like to know if there is a way to do an
alphanumeric sort on some
data. I have item numbers like:
100
100A
200
300XX

A current sort returns
100
200
100A
300XX

Any Ideas?
--
Ray Rohde
.