I'm guessing they're still text becasuse Excel certainly does sort numbers
properly. Excel sorts based on the underlying value, not the format.
Numberformatting doesn't change the underlying data type, it just changes
the look of the real value.
Numbers in Excel are right-aligned by default, text is left-aligned by
default.
To convert to numeric values you can type a 1 in a cell, copy it, select the
numbers, PasteSpecial/Multiply.


--
Tim Zych
SF, CA

"oli merge" wrote in message
...
I notice that unlike Access, Excel doesnt sort numbers in their true
numerical sequence.

e.g. a varying digit ID field I have ends up sorted as such:

1008
1009
101
1010
1011
etc.

Obviously 101 shouldnt be between these values, it should be way before
these particular ones.

The column is formatted as 0 dp numbers.

Is there a simple trick with formatting/ options etc. that will let me see
the results in true numerical order? I wondered about forcing them to all
have the same amount of digits with custom format maybe...

Thanks in advance