'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Showing a Formula Instead of Its Calculated Result
Question details
The user needs to troubleshoot an issue where spreadsheet cells display the raw formula text rather than calculating and showing the final result.
- Product
- Microsoft Excel / WPS Spreadsheet
- Device & OS
- not provided
- Scenario
- Entering, copying, or editing a formula in a spreadsheet cell.
- Observed behavior
- The cell displays the formula itself (e.g., '=A1+B1') as plain text instead of executing it and showing the calculated numerical or text value.
Before troubleshooting, check whether the issue is occurring in a single cell or across the entire worksheet, as this will determine which solution you should apply.
Turn Off the 'Show Formulas' Feature
Use this method if every formula in your entire worksheet is displaying as text instead of showing results.
Excel has a built-in feature designed to display all formulas in a worksheet simultaneously for auditing purposes. If this gets accidentally turned on, no results will be shown.
Open your workbook and click on the 'Formulas' tab located in the top ribbon.
Look for the 'Show Formulas' button in the Formula Auditing group and click it to turn it off. Your worksheet should instantly switch back to displaying calculated results.
Alternatively, you can press Ctrl + ` (the grave accent key, usually located below the Esc key) on your keyboard to quickly toggle this view on and off.
Change Cell Formatting to General
Apply this fix if only specific cells are showing the formula text, which usually happens when the cell is formatted as Text.
Remove Leading Apostrophes or Spaces
Formulas will not calculate if they are preceded by a space or an apostrophe, as these characters force Excel to treat the entry as text.
Use WPS Spreadsheet to Seamlessly Calculate Formulas
WPS Spreadsheet provides robust calculation capabilities and high compatibility with Excel formulas. You can easily manage cell formatting and formula views without unexpected errors, ensuring your data is always accurate.
- 1. Open Your Workbook: Launch WPS Spreadsheet and open the file containing the formula display errors.
- 2. Check Formula View: Navigate to the 'Formulas' tab and ensure the 'Show Formulas' option is toggled off.
- 3. Adjust Cell Format: Select the uncalculated cells, right-click to choose 'Format Cells', and set the format to 'General' under the Number tab.
- 4. Re-enter the Formula: Double-click the affected cell or press F2, then press Enter to trigger the calculation immediately.
Frequently Asked Questions
Why did my cell format automatically change to Text?
If you import data from a CSV file or an external database, the spreadsheet application often defaults to Text formatting to preserve data integrity (like keeping leading zeros). Any formula entered into these cells afterward will be treated as text.
Does the Ctrl+` shortcut work on a Mac?
Yes, pressing Control + ` (the grave accent key) on a Mac will toggle the 'Show Formulas' feature on and off in both Microsoft Excel and WPS Spreadsheet.
How can I recalculate the entire workbook if formulas are still stuck?
If your formulas are correctly formatted as General and lack leading spaces, but still won't calculate, your calculation settings might be set to Manual. Go to the Formulas tab, find 'Calculation Options', and set it to 'Automatic'. You can also press F9 to force a manual recalculation.
