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

Step 1 - Highlight the list of numbers to sort, go to Data, Sort, and click
the descending box. That will put the whole #'s first.

Step 2 - Highlight only the whole #'s then go to Data, Sort, and click the
ascending box. That will put the whole #'s in order from smallest to largest.

Hope that helped.

"Missy" wrote:

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.