In a blank cell such as Cell D2 enter a formula ShowF C2.

How to display text instead of formula in excel. To include text in your functions and formulas surround the text with double quotes. Value if false opposite to previous part this is a value returned if condition is false. If Excel thinks a formula is just text and not an actual formula it will simply display the text without trying to evaluate it as a formula.

On the Data tab find the Data Tools group and click Text to Columns. If a cell has Text formatting applied to it and you enter the formula and hit enter it will continue to show the formula instead of the calculated value. Click the Formulas tab at the top of the window.

Typically the F9 trick is used to troubleshoot formulas. Here is the shortcut. A2 sold B2 units.

The quotes tell Excel its dealing with text and by text we mean any character including numbers spaces and punctuation. Cases where VLOOKUPA3CD2FALSE will display TRUE instead of the desired blank value. First you may have forgotten the equal sign.

If you leave this out Excel will simply treat the formula as text. On step 1 of the wizard select the Delimited file type and click Next. You need to change to a suitable number format instead.

The keyboard shortcut to enabledisable showing formulas as text options is Control. But when you then hit Enter or use any other way to confirm the cell the result will stay in the formula bar and the original formula will be overwritten. Excel Showing Formula Instead of Result How to FIX.