View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Diana Morrison Diana Morrison is offline
external usenet poster
 
Posts: 12
Default Sorting odd numbers

We use a numbering system to sort certain data, i.e.
2007-1 where 2007 is the year, 1 is just a number - it could go up to 1000
2008-1 same as above.
How do I sort this using autofilter? Seems so simple...I've tried to
customize the formatting but couldn't find anything that works.
Thanks,
Diana