• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Techbout

Technology Simplified.

  • iOS
  • Windows
  • Mac
  • Internet

Fix: Formulas Not Working in Microsoft Excel

By: Sam Patwegar | March 16, 2025

In general, an Excel Spreadsheet should automatically calculate the Formulas and display the correct results. However, it is also not uncommon to find Formulas not working in Microsoft Excel.

As you can see in the image below, the Formulas typed in the Cells are correct. However, the formulas are not producing any result and they are just being displayed as Text strings.

Formulas Showing as Text Strings in Excel

This unexpected behaviour in Excel, where users find Formula not working in Excel and being displayed in the form of text string is usually due to the following reasons.

Advertisement
  1. Show Formulas option is enabled in the worksheet.
  2. Calculations Set to Manual
  3. Excel is treating Formula as Text.

Formulas Not Working or Calculating in Excel

If the Formulas are not calculating automatically in Excel, you can end up producing a spreadsheet with errors. Hence, let us go ahead and take a look at the steps to fix the problem of formulas not working in Microsoft Excel.

1. Disable Show Formulas

The “Show Formulas” feature in Excel allows you to see all the Formulas used in the worksheet, so that you can review and correct them as required.

This feature works like a toggle, when it is switched ON it displays the actual formulas used in the Cells and when switched OFF, it displays the calculation results produced by the formulas.

It is likely that you may have accidentally switched on the Formula Mode, resulting in Formulas being displayed in the worksheet.

The most common reason for “Show Formulas” option being accidentally enabled in Excel is due to users typing Control ` , which is actually a Keyboard Shortcut for Show Formula.

1. Select the Formula tab in the top-menu bar and click on Show Formulas option in Formula Audition section.

Show Formulas Option in Excel

Now, you should be able to see a regular worksheet with results of the Formulas being visible in the Cells.

2. Enable Automatic Calculations

It is possible that Formulas are not working due to calculation option for the worksheet being set to manual mode.

1. Select the Formulas tab in the top-menu bar > click on Calculation Options and select the Automatic option in the drop-down menu.

Set Calculations to Automatic Mode in Excel

Once, calculations are set to Automatic mode, you will see Formulas producing results as soon as you type them.

3. Excel Treating Formula As Text

If you find a Single Formula or Formulas in a few Cells not working, the problem is not due to “Show Formulas” option being enabled.

In this case, the problem is due to Excel treating formula in a certain Cell or group of cells as Text.

When Excel treats a Formula as Text in any Cell, it simply displays whatever the Formula is typed or entered in the Cells and does not try to evaluate the Formula.

There could be many reasons for Excel treating Formula as text. So let us go ahead and rule out many of these reasons.

3.1. Formula Enclosed in Quotes

Make sure that the Formula is not enclosed in quote marks (” “). If the Formula is enclosed in quote marks, Excel will treat the Formula as a Text string.

This problem usually occurs due to users copying Formulas from websites along with the quote marks (” “) used to highlight the Formula.

1. Click in the Cell containing the Formula and see if the Formula is enclosed in Quotes.

Excel Formula Enclosed in Quotes

Simply, remove the quote marks and you will see the Formula working and producing the desired result.

Note: You are allowed to use quotes inside the formulas, but not to enclose the Formula in quotes.

3.2. No Equal Sign in Formula

When you manually type a Formula in Excel, the Formula should always begin with an Equal sign (=).

Excel Formula Without Equal Sign

If you forget to begin a Formula without an Equal (=) sign, Excel won’t be able to sense that you are actually typing a Formula.

3.3. Space Before Equal Sign

Another common reason for Formula not working in Excel is due to the presence of a Space before the Equal (=) sign.

As you can see in the image below, Formula starting with a space before the equal sign is being treated as text by Excel.

Space Before Formula In Excel

To fix this issue, select the Cell containing Excel Formula > click in the Formula bar and remove the Space before the Equal sign.

3.4. Cell Format Set to Text

If everything about the Formula appears right and yet the Formula is not working, it is likely that the Cell containing the formula is in Text Format.

1. Right-click on the Cell containing Formula and select Format Cells… option in the drop-down menu.

Format Cell Containing Formula

2. On Format Cells screen, set the format to General or to a particular Number Format in which you want to display the result produced by the formula and click on OK.

Set Cell Format to General

3. After changing Number Format, select the Cell Containing Formula > click into the Formula bar and hit the Enter key on the keyboard of your computer.

Formula Bar in Excel

You should now see the Formula working and producing results.

Sam Patwegar

Brings practical experience in technical writing from an engineering background to produce fluff-free, easy-to-follow and well tested troubleshooting guides and informative tech-related articles on this website.

Related
  • How to Setup Recurring Meeting in Microsoft Teams
  • How to Start New Line in Excel Cell
  • How to Create Two Pivot Tables in Single Worksheet

Primary Sidebar

Advertisement

Recent Posts

  • Fix: System Tray Icon Missing in Windows 11/10
  • How to Use Internet Explorer in Windows 11
  • Fix: Cast to Device Not Working in Windows 11/10
  • Fix: MacBook Camera Not Working Issue
  • Multiple Ways to Disable Face ID on iPhone

© 2025 Techbout.com · All Rights Reserved
About | Privacy Policy | Terms | Contact
Twitter(X) | Facebook