Find records with values more then 2 decimal places.
 

I have a column of data that has a bunch of varing length of data. I want to
know how can I find all the records that have more then 2 decimal places.

Thanks

Answer: Find records with values more then 2 decimal places.
 

Here is the formatted text:

Here are the steps to find records with values more than 2 decimal places in Microsoft Excel:

1. Select the column of data that you want to check for decimal places.
2. Click on the "Home" tab in the ribbon.
3. Click on the "Number Format" drop-down menu in the "Number" group.
4. Select "More Number Formats" at the bottom of the menu.
5. In the "Format Cells" dialog box, select the "Number" tab.
6. In the "Category" list, select "Custom."
7. In the "Type" field, enter the following format:
   Code:

   ---

   0.00##

   ---

8. Click "OK" to close the dialog box.

Now, any cell in the selected column that has more than 2 decimal places will display the extra decimal places. You can then filter or sort the data to find the records that meet your criteria.

Find records with values more then 2 decimal places.
 

Wasn't sure what you wanted to do with it when you found it...

Use this with Conditional formatting - formula is: to highlight cells with
more than 2 decimal places.
=A19<ROUND(A19,2)

Add this formula to an additional cell to have it list just the decimal
portion of the number if greater than 2 places, or blank if not.
=IF(A19<ROUND(A19,2),A19-INT(A19),"")

"Nicholas" wrote:

I have a column of data that has a bunch of varing length of data. I want to
know how can I find all the records that have more then 2 decimal places.

Thanks

Find records with values more then 2 decimal places.
 

Thanks.. This will give me what I need.

"BoniM" wrote:

Wasn't sure what you wanted to do with it when you found it...

Use this with Conditional formatting - formula is: to highlight cells with
more than 2 decimal places.
=A19<ROUND(A19,2)

Add this formula to an additional cell to have it list just the decimal
portion of the number if greater than 2 places, or blank if not.
=IF(A19<ROUND(A19,2),A19-INT(A19),"")

"Nicholas" wrote:

I have a column of data that has a bunch of varing length of data. I want to
know how can I find all the records that have more then 2 decimal places.

Thanks