One way:

Assuming your numbers are in column A, in a free column, enter

=ABS((A1-ROUND(A1,0))) < 1E-10

and copy down. Sort on this column. The TRUE values are whole numbers.

Adjust 1E-10 to be smaller than the precision of your values (e.g., if
your values have a maximum of 2 places after the decimal point, you
could, if you wanted to, use 1E-04 instead.

In article ,
wstruse wrote:

Could someone tell me how to sort out the whole numbers in a column of
mixed numbers? (decimals and whole numbers )

Thank you in advance,

wstruse