View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Carol Carol is offline
external usenet poster
 
Posts: 115
Default Numerical Sorting

I have a numerical sorting issue with project numbers that sort as follows
(not in correct numerical order):

2008-01
2008-010
2008-0100
2008-02
2008-1
2008-2
2008-200
2008-3

The problem is that Excel sorts by the first number it sees - so 010 would
come before 1.