View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Shorty[_3_] Shorty[_3_] is offline
external usenet poster
 
Posts: 19
Default Sorting Data, Text and Numeric

The easiest way ive found is just to add a '0' to the lower numbers,
ie:

86 4:57 NG08
87 5:17 NG09
88 5:33 NG10
89 1:01 NR01
90 1:37 NR02
91 2:12 NR03

though i dont really want the 0 in the data its the easiest way to do
this. if anyone knows of a better work round or the real method to sort
this keep the posts comming!