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

Q: I have an Excel spreadsheet. I want to replace all the blank cells with a zero. How do I do this easily and quickly? A: This trick for entering a zero into each empty cell is invaluable to teachers ...

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 ...