Is there a formula to delete whole numbers but leave decimals?

Hi all,

I've got a spreadsheet that's basically a large list of numbers, both whole and decimal.
For example, let's say this is in cells A1-A5:

4
0.65
1.34
3
8.2

Is there a formula to get rid of all of the whole numbers but leave the decimals?
(What I mean by that is I don't need 4 or 3 as they're whole, but I need the decimals to be left alone)

I know it's probably a really awkward question but I have over 2,000 lines to go through, it will take a long time to do manually.

Perhaps if it's not possible to a formula to delete entries, maybe just make all whole numbers say something like "NO", so that I can sort the column in A-Z order and delete all of the 'NO's quickly by highlighting them all together.

I hope that makes sense.

Any help is appreciated!

Thanks a lot

Skye

Here is a VBA solution

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Originally Posted by Miss Molko

All whole numbers don't have any decimals at all, they are just one digit.

Thank you!!

Whole numbers can be represented as a single digit or a digit with decimal places: 4 and 4.00 are both the same, and both are whole numbers.