Cannot find 0's or blank cells

[lisaspencer]

I've got a column with formulas all the way down. The values end up being accounting figures. Some have figures, some are £0.00. I want to 'find' all the 0's so I can quickly delete them from the list. But I've tried every way on the 'Find' method and the 'Go to special' method and it either lists the digit '0' which appears in figures such as "£12.90", or it highlights them all because I've likely put in the wrong digit. Screenshots below to show. I've tried every option of 'match case' or 'match entire cell contents' and both at the same time, and i've tried no formatting and all versions of formatting using currency, accounting, general, number etc. Not sure why it won't find the blank or 0 cells even though it is using a formula

 

[Fluff]

It's an odd one. If the format is currency you can use £0.00 in the find what box & it works, but can't remember what you need to type for accounting.

 

[lisaspencer]

Column I:

Column J:

 

[Joe4]

Did you see what Fluff said?
Let's confirm that is what is going on in your case.

If you temporarily try changing the format of that column's cells from Accounting to General, does your FIND work then?

 

[lisaspencer]

Yeah i've changed the format back to general and its found them perfect. Thats bad design from excel if they won't allow it to be found for accounting. Thanks for the help anyways! If you happen to remember it, let us know!