View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lise Lise is offline
external usenet poster
 
Posts: 102
Default sorting sequentially

Hi

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

--
Thanks

Lise