It sounds like you want the entry sorted like it was text.

I'd insert a new column and use a formula like:
=a1&""
to convert the number to text

Wait, I guess, you'd want to keep that same format:

So maybe something like:
=text(a1,"00000")
for 5 digit part numbers.

A. Roger wrote:

Hello,
I have an inventory sorted by ascending part numbers(smaller to largesr).
But i would like for the order to start with numbers that begin with a 0 then
with numbers that start 1 and so on, regardless if the number is smaller or
bigger.

Is this possible?

--

Dave Peterson