Learn how to remove formula in Excel and keep the text. Use Paste Special option to delete formulas without removing values in Excel.

The #NUM error occurs in your Excel spreadsheet when a function or formula contains invalid numeric values. Remove #NUM errors this way!