Excel showing formula instead of result, and how to tell which

1. Look at how many cells are affected before touching anything. If every formula on the sheet is showing, it is the Show Formulas switch. If it is one cell or one column, it is either the format of those cells or the way the entry was typed. That observation decides where on this page to start.
2. For the whole sheet: go to Formulas and select Show Formulas. It is a toggle, so selecting it again puts the results back. Microsoft’s wording: “Select Formulas and then select Show Formulas to switch between displaying formulas and results.”
3. Or press Ctrl and the grave accent. Microsoft writes it as “CTRL + ` (grave accent)”. On a US keyboard that is the key to the left of the number 1, the one that shares its place with the tilde — not the tilde itself.
4. For one cell: change the format, then re-enter the formula. Changing the format alone does nothing to a cell that already holds text; the entry has to be made again afterwards. Select the cell, set the format to General, press F2 and then Enter.
5. If the cells hold numbers rather than formulas, use the error indicator. Select the cells, click the warning marker in the top-left corner of the selection — Microsoft also gives the keyboard route, Alt+Shift+F10 — and choose Convert to Number. That route is for numbers stored as text; a formula stored as text still has to be entered again.
6. If there is no warning marker, switch the checking back on. File, Options, Formulas, and under Error Checking tick “Enable background error checking”. Microsoft documents this as the reason the button can be missing.

The second cause needs two actions, and that is why it looks unfixable. A cell formatted as Text stores what you typed as characters. Setting the format back to General does not reinterpret what is already in there, so the cell goes on showing its text and the obvious conclusion — that changing the format did not work — is wrong. The format decides how the next entry is read. Press F2 and Enter afterwards, and the same characters are read as a formula.

Microsoft names this exact symptom on the page about numbers kept as text: “Numbers that are stored as text can cause unexpected results, like an uncalculated formula showing instead of a result.” The same page gives the bulk repair for numbers kept as text — select the cells, open the error indicator, choose Convert to Number — and the keyboard route to that menu, Alt, Shift and F10. If the indicator is not there, background error checking has been turned off, and Microsoft gives the switch: File, Options, Formulas, Enable background error checking.

There is a third reason an entry never becomes a formula, and it has nothing to do with cell formats. Excel only treats an entry as a formula if it begins with an equals sign. Exceljet lists the ways that rule gets broken in practice: no equals sign at all, a space before it, or the formula wrapped in quotation marks — and quotes, in Excel, mean a text value, so the formula is never evaluated. A leading apostrophe does the same thing on purpose, which Exceljet suggests as a way to park an unfinished formula without an error. Any of the three produces a cell that shows its own formula, and none of them is a bug.

One warning about a Microsoft page that sounds right and is out of date. The support article “Fix text-formatted numbers by applying a number format” walks through three techniques and is worth reading, but its Applies To line says Excel 2013 and nothing else. The observation it opens with holds anyway — text-formatted numbers are “left-aligned instead of right-aligned in the cell, and are often marked with an error indicator” — and that is the part cited here.

If the formula shows and also refuses to calculate elsewhere, the problem may not be display at all. A rule that looks correct and does nothing is the same family of question as conditional formatting with a formula, where a missing equals sign produces a rule Excel quietly turns into text. And if the cells refuse to be edited rather than refusing to calculate, locking and unlocking cells is the page for that: every cell in a new sheet is already locked, and only protection makes it bite.

Two smaller things worth knowing while you are here. Once the formulas do run, does not equal is two characters, written differently in four places. And if the numbers arrived from somewhere else, Microsoft’s 2013 page warns that numbers kept as text can “produce confusing sort orders”, which is where sorting comes in.

The shortcut, the menu routes, the symptom sentence and the protection case are quoted from Microsoft’s own Excel pages, read in full on 24 September 2026 and listed below; the ways an entry ends up as text are from Exceljet. The reading of why changing the format alone does nothing, and the advice to count the cells first, are ours.

Not covered here. It does not cover Google Sheets, where the same view has a different name and a different menu.

It does not cover a formula that returns an error rather than showing itself: that is a different set of messages, each with its own cause.

And it does not recommend anything to install. Every route here is a ribbon tab or one key in the program the workbook is already open in. What holds instead is simple: the shortcut and the menu routes are quoted from Microsoft’s own Excel pages, with the date each was read.