If you have used multiple functions in a spreadsheet and now you want to remove all of them but keep the values, here is how you can do that. There are mainly two ways to remove the formula in Excel ...

The text trap: If you select numbers and the status bar stays blank (or only shows the Count), your numbers are formatted as text—and Excel can't sum words! This tells you that you should click the ...