Thanx Gord,
I'm also using Excel2003 but when I sort it, first the numbers line up and
then the numbers with dash numbers and at the end the part numbers starting
with letters like below:
103528
205999
205999-011
205999-051
pl705280
pl705283

Any suggestions?
Peiman




"Gord Dibben" wrote:

Some of the numbers are text so you can't formatcellsnumbers

Your example input data sorts into your example output data in my Excel 2003

What results are you getting?


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 15:27:01 -0700, peyman
wrote:

Hi,
I've got a list of part numbers like:
205999
pl705283
pl705280
205999-011
103528
205999-051
How can I sort this column to have the part nos. like below?Should I change
the "format cells/numbers" for the cells of this column:
sorted coulmn:
103528
205999
205999-011
205999-051
pl705280
pl705283
Thanx for ur help.
Peiman