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 ...
Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
We noted that Excel turned 40 this year. That makes it seem old, and today, if you say “spreadsheet,” there’s a good chance ...
Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.