How to fix excel formulas showing as text in Excel

August 1, 2022
18.4K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

Have you been working on an Excel document that contains formulas with text instead of the result you would typically, see? If that sounds familiar and you have no idea how to fix this issue, wait no more. You can fix this problem easily. Misleading and disconnected data quickly renders a spreadsheet useless. If you're not getting any formulas to appear in Excel, there can be several causes for this malfunction.

Sometimes you are working on a project in Microsoft Excel, but the formulas and functions are displaying as text instead of their actual values. Are you getting frustrated? If so, you're not alone. This issue can be very frustrating, as well as time-consuming. This article shows you the causes of this issue and gives some tips on troubleshooting. You will learn to solve these problems on your own and even prevent others from happening in the future.

Tips that are provided in this article are compatible with versions 2010/2013/2016.

How to Fix Excel Formulas showing as Text  in Excel: Turning off Show formulas Feature

When you are working with a large spreadsheet, it is expected that you may lose the focus of your work. You may have spent a lot of time creating an excellent formula, and when you come back to see it, you realize that the procedure has been changed into text. The reasons for this can be many, but one of them is probably turning off the Show formulas feature.

1. If needed, you can quickly fix this problem by turning on the Show formulas feature and changing its default setting. Below are steps on how to do these:

2. Select the “Show Formulas” option

3. If it’s enabled, then disable this option

This will fix your error; that’s how to fix excel formulas showing as text in Excel.

How to Fix Excel Formulas showing as Text  in Excel: Disable Cell Formatted as Text

The easiest way to fix this error is by disabling the cell formatted as text option in Excel. This option helps in preventing the spreadsheets from converting formulas into text format automatically whenever they are copied or pasted into another cell.

1.Select the format cell options and make sure this option is disabled.

2.This will fix your error of excel formulas showing as text.

How to Fix Excel Formulas showing as Text  in Excel: Copy and paste work into a new worksheet

If none of the above works, then the final solution is easy and simple, but you need to copy and paste the formula from the original sheet into a new sheet.

Let's see how to do it:

1. Open the spreadsheet containing the formula that shows as text. In this example, we have an inventory list that shows as text instead of numbers.

2. Select all cells (Ctrl + A).

3. Now, right-click on one of these cells and select Copy from the context menu.

4. Click on any empty cell on a different worksheet in your workbook and right-click on it; then select Paste Special from the context menu. In the Paste Special dialog box, click on the Values option under the Paste option, then click the OK button at the bottom.

Did you learn about how to fix Excel formulas showing as text in Excel?. You can follow WPS academy to learn more features of Word documents, Excel Spreadsheets, and PowerPoint slides.

You can also download WPS Office to edit word documents, Excel Spreadsheets, and PowerPoint free of cost. Download Now! And get an enjoyable working space.