Custom Sorting.

  • Thread starter Thread starter A. Roger
  • Start date Start date
A

A. Roger

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?
 
Numbers can't start with zero so those must be text.

Text and numbers sort separately.

You could use a helper column with a formula of =LEFT(A1) copied down.

Copy/paste special/values.

Select both columns and sort by helper column.


Gord Dibben MS Excel MVP

On Tue, 19 May 2009 09:02:01 -0700, A. Roger <A.
 
Check your other post.

A. Roger said:
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?
Click to expand...
 
Back
Top