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