Thread: Find 0.00%
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Find 0.00%

Cells have
Format: Number
Category: Percentage
Decimal places: 2

How do I find cells whose contents are displayed as 0.00%


Select all the cells you want to search in (for this question, that is
probably all the cells on the worksheet) and press CTRL+F to bring up the
Find dialog box. First, make sure the "Find what" field has nothing in it.
Next, if all the options are not displayed, click the "Options" button to
reveal them. Now look to the right of the "Find what" field... you will see
a "Format" button... click it. On the "Find Format" dialog box that appears,
select the Number tab and then select Percentage from the Category list and
select 2 in the "Decimal places" field, then click the OK button. Now click
the "Find All" button, then press CTRL+A and finish off by clicking the
Close button. All the cells within the original selection that are formatted
a Percentage with 2 Decimal Places will all be selected.

Rick Rothstein (MVP - Excel)