Once we click on those options all the formulas in the excel sheet will be visible instead of the values of the formula. Click the Home tab. Open the desired Excel sheet and click on Formulas tab available on Menu Bar.
Click on Show Formulas option in Formulas tab available under Formula Auditing Section.
Show formulas in cells of all worksheets or active worksheet with Kutools for Excel quickly. Click the Review tab and then click Unprotect Sheet. If Excel thinks a formula is just text and not an actual formula it will simply display the text without trying to evaluate it as a formula. In this example we see that the number of numeric values returns with the COUNT function doesnt include the dashes.