Find Cells Containing a Specific Number Format

I am trying to write code that would find cells containing numbers formatted a certain way and then do some operations on those numbers.

The If statement below is able to identify some formatting, but I can't get it to identify a number with two decimal places.

I would like to change numbers such as 17.55 and ignore whole numbers, such as 17.

I tried both If cell.NumberFormat = "#.##" and If cell.NumberFormat = "0.00" but neither of those works.

When I run If cell.NumberFormat = "0.00%" it is able to find cells containing percentages with that format.

How can I change the If statement to identify only numbers with two decimal places?

Please Login or Register  to view this content.

Thank you. It looks like If cell.NumberFormat only works when the selection is already formatted as a number. It does not work when it is set to General.

However, If cell.Value <> Int(cell.Value) does work when it is set to General. The problem now is that I get an error since some of my cells have text in them.

Any way around that?

Perfect, thanks!

Originally Posted by AlphaFrog

Please Login or Register  to view this content.