software

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.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.

quot;Missyquot; wrote:

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

I tried but it's not sorting like you say. It puts them in the order that i
have them typed below .38, .62, 1, 1.29, 1.67, 2
Is there a setting somewhere that would make this work?

quot;Kim17738quot; wrote:

gt; Step 1 - Highlight the list of numbers to sort, go to Data, Sort, and click
gt; the descending box. That will put the whole #'s first.
gt;
gt; Step 2 - Highlight only the whole #'s then go to Data, Sort, and click the
gt; ascending box. That will put the whole #'s in order from smallest to largest.
gt;
gt; Hope that helped.
gt;
gt; quot;Missyquot; wrote:
gt;
gt; gt; If I have a list of numbers - say .38, .62, 1, 1.29, 1.67, 2, etc.
gt; gt; How can I sort the list to have the whole numbers first, (1, 2) then the
gt; gt; list of other numbers? If I data sort it puts them in the order I have
gt; gt; listed.
gt; gt;

Make sure when you go to Data, Sort, that you are selecting the Descending
box. It should sort from largest # to smallest #. Then go back and
highlight just the whole #'s and resort with the Ascending box checked. Make
sure you highlight what you want sorted.

quot;Missyquot; wrote:

gt; I tried but it's not sorting like you say. It puts them in the order that i
gt; have them typed below .38, .62, 1, 1.29, 1.67, 2
gt; Is there a setting somewhere that would make this work?
gt;
gt; quot;Kim17738quot; wrote:
gt;
gt; gt; Step 1 - Highlight the list of numbers to sort, go to Data, Sort, and click
gt; gt; the descending box. That will put the whole #'s first.
gt; gt;
gt; gt; Step 2 - Highlight only the whole #'s then go to Data, Sort, and click the
gt; gt; ascending box. That will put the whole #'s in order from smallest to largest.
gt; gt;
gt; gt; Hope that helped.
gt; gt;
gt; gt; quot;Missyquot; wrote:
gt; gt;
gt; gt; gt; If I have a list of numbers - say .38, .62, 1, 1.29, 1.67, 2, etc.
gt; gt; gt; How can I sort the list to have the whole numbers first, (1, 2) then the
gt; gt; gt; list of other numbers? If I data sort it puts them in the order I have
gt; gt; gt; listed.
gt; gt; gt;