hi

maybe. custom sorts are usually done with the use of a helper column. you

could add a column at beginning of the data or use the last column next to

your data.

in the column, enter the following formula....

=left(A2,1)

this will pull the first number from your inventory number.(accually if some

of your numbers start with zero, they are probably formated as text)

you can then sort your data using the helper column as the primary sort, and

maybe another column as a secondary sort.

or maybe you need the first 2 numbers of your inventory number

=left(a2,2)

look up the left function in xl help for more details.

regards

FSt1