Find 0.00%
Cells have
Format: Number Category: Percentage Decimal places: 2 How do I find cells whose contents are displayed as 0.00% |
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) |
All times are GMT +1. The time now is 05:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com