How-To Geek on MSN

The 4 Excel find and replace tricks I use to save hours

Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
How-To Geek on MSN

Stop using format painter in Excel: Find and replace formatting instead

Excel saves your previous formatting criteria, so to avoid confusion, you need to clear them. Click the down arrow next to the Find What field, and select "Clear Find Format." Then, click "Clear ...