Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...

First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...

If you see the error “This value doesn’t match the data validation restrictions defined for this cell” when entering a value in an Excel cell, the solutions ...