Find records with values more then 2 decimal places.

[Guest]

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

 

[Guest]

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),"")

 

[Guest]

Thanks.. This will give me what I need.

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),"")