Instead of labeling new entries
BE-
Try using
BE-9999

That'll sure put them at the, wouldn't it ?

And of course, dragging down at least the last 2 old entries will overwrite
the 9999.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jmt" wrote in message
...
I have an inventory sheet where items are listed as: BE-01, BE-02...,
PE-01,
PE-02... etc. When I add new items I indicate a preliminary inventory as
(ie) BE- in the inventory number column. When I am done I may have
several
items that have BE- in the inventory number column. When I sort the
worksheet, all the BE- items end up together, but they sort before BE-01,
BE-02... I want them to sort at the end of the BE group so I can assign
an
inventory number by dragging the cursor to continue the series. How can I
do
that?