Search results
Encounter Excel formulas showing instead of results? Discover common causes and step-by-step solutions to resolve this common Excel issue.
- Contact
More results... Generic selectors. Exact matches only ....
- Contact
There are two main reasons you might see a formula instead of a result: You accidentally enabled Show Formulas; Excel thinks your formula is text; I'll walk through each case with some examples. Show Formulas is enabled. Excel has a feature called Show Formulas that toggles the display of formula results and actual formulas.
22 lip 2024 · The cell is formatted as text -- format the cell as General, then edit the cell and hit enter again. To check if Show Formulas is turned on, visit the Formula tab in the ribbon and check the Show Formulas button (if Show Formulas enabled - just click to disable).
10 lip 2017 · Usually when I have a simple formula in Excel (A1+A2) if I click in cell containing the formula a blue and a pink box will highlight cells A1 and A2 and I can move the reference point around if I like.
13 wrz 2014 · When hitting enter, or clicking another cell after getting the cell in edit-mode, the cell stopped showing the formula result and instead showed the formula. e.g cell was showing "102". Double-click and it showed =100+2.
8 lis 2023 · Excel doesn’t evaluate it and displays the formula itself. Luckily, there aren’t too many things that could have gone wrong here so there isn’t a need to panic or delete or overwrite cells. There are a few reasons the formula shows up in place of the result and there’s an easy fix for each.
21 mar 2023 · The most common reason for an Excel formula not calculating is that you have inadvertently activated the Show Formulas mode in a worksheet. To get the formula to display the calculated result, just turn off the Show Formulas mode by doing one of the following:
