Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
Learn advanced filtering in Excel with a criteria area, OR and AND logic, and copy results to isolate the right rows fast.