This sort-by-helper col easy tinker might suffice for you
Assuming data as posted in A2 down
In B2: =LEFT(A2,5)+0
Copy down. Select both cols A and B, sort by col B, ascending.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"Lise" wrote:
I have a column of numbers as below and want to sort numerically so that all
the 02002's follow on from each other but can't seem to get this to happen
all numbers that have -## at the end are sorting to the bottom - what am i
doing wrong please?
02002
02010
03001
03002
02002-01
02002-02