View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
M M is offline
external usenet poster
 
Posts: 1
Default First key sort order

Under sort options, I have selected a first key sort order of "1, 1A, 1B". I
would like to be able to sort in the order "1, 2, 2B, 3, 4A, 4B, etc." It
seems that no matter how I format the cells in the colum, alphanumerics
always are sorted AFTER numbers. Keep in mind, this is the second sort
criteria and some cells in this column are blank. What am I missing?