It's 4:30 PM on your first Friday. Your manager asks you to pull numbers for the weekly update deck before everyone leaves for pub drinks. You carefully write an XLOOKUP, press Enter, and... nothing happens. The cell doesn't calculate. It just sits there, displaying the raw formula text like a mocking comment block.
You delete it and write it again. Still text. You look over your shoulder to see if your supervisor is watching your screen. Excel isn't crashed, and you haven't broken the system. It is just playing a very common, very easy-to-fix trick on you.
Here are the four reasons your Excel formula is showing as text instead of the result, and how to fix each one in under ten seconds.
This is the cause of ninety per cent of formula-to-text issues, especially in databases exported from internal company software.
If a cell is formatted as Text before you type a formula, Excel treats the formula as a literal string of text, ignoring the calculation request entirely.
The 10-second fix
Select the broken cell(s) and go to the Home tab. Change the number format dropdown (which likely says "Text") to General.
Crucial step: Simply changing the format will not recalculate the cell immediately. You must click into the formula bar (or press F2) and press Enter to force Excel to re-evaluate it.
If you have a whole column of these, select the column, then click Data → Text to Columns → click Finish. This instantly converts the entire column's formats and calculates the formulas.
Excel has a built-in mode designed for auditing that displays the formulas in every single cell instead of their values.
It is very easy to turn this on by mistake if your hand slips while typing keyboard shortcuts.
The 10-second fix
Toggle the shortcut to turn this mode off:
Alternatively, navigate to the Formulas tab on the Ribbon and click the Show Formulas button to deselect it.
Every calculation in Excel must begin directly with the equals sign. If there is a space, an apostrophe, or a stray letter before the =, Excel parses it as a sentence.
This frequently happens if you copy-paste a formula snippet from a website or chat thread.
The 10-second fix
Look closely at the formula bar for the selected cell. Delete any leading spaces or apostrophes (') sitting before the =, then press Enter.
While this won't technically display the formula as literal text, it has a very similar and equally confusing symptom: your cells refuse to calculate new values and appear completely frozen, keeping their old results or remaining blank.
When working with large client workbooks, senior analysts often set calculations to manual to prevent Excel from crashing every time a row is added.
The 10-second fix
Go to the Formulas tab on the Ribbon, click **Calculation Options**, and change the setting to **Automatic**.
If you want to keep manual calculation on but want to force a refresh right now, press F9 to recalculate your entire workbook, or Shift + F9 to recalculate just your active sheet.
Summary Reference
Keep this checklist on hand for the next time your report breaks under pressure:
| The Issue | The Check | The 10-Second Fix |
|---|---|---|
| Formatted as Text | Is cell format set to "Text"? | Set to General → Press F2 → Press Enter |
| Show Formulas Mode | Are formulas showing in ALL cells? | Press Ctrl + ` |
| Stray Leading Space | Is there a space before the =? | Delete the space in the formula bar and press Enter |
| Manual Calculations | Are formulas refusing to update? | Go to Formulas → Calculation Options → **Automatic** (or press F9) |
Excel isn't broken. It's just following your styling instructions a little too literally.
The Bigger Picture
Getting stuck on a simple formatting trap on your first month is a rite of passage on any graduate scheme. The difference between feeling out of your depth and looking like a spreadsheet pro is knowing how to translate Excel's visual behavior into a simple setting adjustment.
Next time a formula refuses to compute, don't delete it. Just check the cell's number format, toggle the view, and get back to your deliverables before your manager asks for that status update.
The whole toolkit on one page.
XLOOKUP, SUMIFS, IFERROR, TRIM, the 15 shortcuts, the data-cleaning helpers, Mac and Windows. The 1-page Grid & Formula survival sheet has all of it. Printable PDF, instant download.
Get the sheet — £11