View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JLW
 
Posts: n/a
Default alphanumeric sort

I would like to sort values for numbered connectors such as C1, C2, C3,
....... C200. However, excel is sorting it as C1, C100, C11, C123, etc. How
do I change this???