How to fix excel formulas showing as text in Excel
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel