Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
Microsoft Excel relies on two fundamental reference types when addressing other cells. Absolute references -- which are denoted with a "$" -- lock a reference, so it will not change when copying the ...
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 ...