The keyboard shortcut to enable/disable showing formulas as text options is Control + ` In the Formula Auditing group, click on Show Formulas.This problem has an easy fix – you just need to disable ‘Show Formulas’ option (which might be enabled and is causing this issue) There could be multiple reasons for this, the most common one is when you’re auditing the worksheet and need to know where and what formulas are being used.
In some cases, people actually want to see all formulas as text in the worksheet. Show Formulas May Be Enabled (Top Reason for Formulas Showing as Text)
