Thread: SORT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
peyman peyman is offline
external usenet poster
 
Posts: 189
Default SORT

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