Formula Errors

How to Fix Excel Formulas Replaced by Plain Text or Values

Maira Mehtab Sep 25, 2026 870 views

Question details

Users are experiencing an issue where spreadsheet formulas are displaying as plain text or have been replaced by static values instead of calculating their expected results.

How to Fix Excel Formulas Replaced by Plain Text or Values

Product: Excel
Device & OS: not provided
Scenario: Calculating formulas or attempting to update data that relies on external links to another sheet or workbook.
Observed behavior: Formulas that should calculate and retrieve data appear as plain text strings or static numbers within the cells.

Before you start

Before troubleshooting, check if you have accidentally enabled the 'Show Formulas' feature in the Formulas tab, which displays all formulas as text across the entire worksheet.

Solution 1Recommended

Change Cell Formatting to General

Formulas will display as plain text if the cell is formatted as Text or preceded by an apostrophe. Changing the format allows the software to calculate the formula.

When a cell is formatted as Text before typing a formula, the application treats the equal sign and function as a literal text string rather than an active calculation.

Select Cells

Select the cell or range of cells where the formula is showing as plain text.

Modify Number Format

Go to the 'Home' tab on the ribbon and locate the 'Number' group. Click the dropdown menu and select 'General'.

Re-evaluate Formula

Double-click the affected cell or press 'F2' to enter edit mode, then press 'Enter'. The formula will now calculate and display the correct value.

Apostrophe Prefix: If you see an apostrophe (') at the very beginning of the formula in the formula bar, delete it and press Enter. This symbol forces cells to behave as text.

Solution 2

Check and Update External Workbook Links

If formulas retrieve data from external workbooks, broken or disabled links can cause the application to replace those formulas with static values.

Solution 3

Restore File from Version History

If formulas were permanently overwritten with static values (e.g., via Paste Special), you can restore a previous version of your cloud-saved workbook.

Seamless Spreadsheet Management

Calculate and Manage Formulas Easily with WPS Spreadsheet

WPS Office provides a powerful, highly compatible spreadsheet editor that perfectly handles complex formulas, cell formatting, and external data links, ensuring your data calculates accurately without unexpected text errors.

1. Open Your Workbook: Launch WPS Spreadsheet and open your existing spreadsheet file.
2. Format Cells Correctly: Highlight the cells displaying formulas as text, right-click, select 'Format Cells', and change the category to 'General'.
3. Calculate the Result: Double-click inside the cell or press F2, then press Enter to trigger the calculation.
4. Manage Data Links: Go to the Data tab and select 'Edit Links' to securely manage and update any external workbook references.

Fully compatible with Microsoft Excel (.xlsx) formats and standard formula syntax.Easily toggle cell formats between Text and General to instantly fix formula display issues.Manage external links and data references seamlessly with an intuitive user interface.Free, lightweight, and efficient alternative for all your daily spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my formulas suddenly change to values without me doing anything?

Formulas can convert to static values if you or a collaborator accidentally copy and use 'Paste as Values', or if the external workbook they are linked to is moved, deleted, or becomes permanently inaccessible, prompting the software to lock the last known values.

How do I quickly toggle between showing formulas and their results?

You can easily switch between displaying formula results and the underlying formulas by pressing 'Ctrl' + '`' (grave accent) on your keyboard, or by clicking the 'Show Formulas' button located in the Formulas tab on the ribbon.

Does clicking 'Clear Formats' fix the formula text issue automatically?

Clicking 'Clear Formats' resets the cell, but it will not automatically re-calculate the text string. You still need to enter edit mode (by pressing F2 or double-clicking the cell) and press Enter for the application to recognize the text as an executable formula.

Excel & Data Problems