Find records with values more then 2 decimal places.

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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),"")
 
Thanks.. This will give me what I need.

BoniM said:
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),"")
Click to expand...
 
Back
Top