How to tell if an Excel cell has a formula or is hardcoded?
Use Conditional formatting. Choose the "Use a formula to determine which cells to format" option and type " =NOT(Cellhasformula) ". This will format anything that is hardcoded.
Select the cells in question, press Ctrl+G and then select Special to get the following dialog box:
Then specify the type of cells you want and click OK and only those types of cells will remain selected.