Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
Normally what we do is just press “CTRL + F”, enter ‘*’ in the ‘find’ field and click on “Find All”. It will show all the entries in the search result and there is no confusion in that. When we search ...
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 ...