Is there a way to delete decimal numbers only?

[christris]

Hello,

I'm wondering if there is a way to delete only numbers ending in a decimal from a column of numbers? I have a column of numbers but only the non decimals are relevant to the next equation. Is there an easy way to do this?

[shg]

You could copy a formula down: =MOD(A1,1)=0, and then delete the values where the formula is false.

[martindwilson]

Or to extend on that
=IF(MOD(A1,1)=0,A1,"") then copy past back special values
or even find/replace
find *.*
replace with nothing

[christris]

Thanks for the help those were exactly what I needed.