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

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...