View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Missy
 
Posts: n/a
Default Advanced Sorting #'s??

If I have a list of numbers - say .38, .62, 1, 1.29, 1.67, 2, etc.
How can I sort the list to have the whole numbers first, (1, 2) then the
list of other numbers? If I data sort it puts them in the order I have
listed.