Menu
I've written a formula within an Excel Cell, in Office 2010, and I expect the cell to show its value, but it still shows the formula. How do I get the cell to show the value rather than the formula?
897
Go to the Options. Now Click on Advanced. Then go to the Display options for the portion of the worksheet and select the worksheet name from the drop-down. Make sure that the Show formula in cells instead of their calculated result box is unchecked. Finally, click OK. We can see that Excel is showing results instead of formulas.
Select the cell with the formula, press F2, and then press ENTER. The cell displays the value. In the same cell, click Cells on the Format menu.
Click the Formulas tab. In the Formula Auditing group, click on Show Formulas. The keyboard shortcut to enable/disable showing formulas as text options is Control + `. In most cases, this should fix the problem and your formulas should show the result and not show up as text itself.
Show Formulas is enabled. Excel has a feature called Show Formulas that toggles the display of formula results and actual formulas. Show Formulas is mean to give you a quick way to see all formulas in a worksheet.
You might be in formula view:
Hit Ctrl + ` to switch
100
Make sure the format of the cell is set to 'general' not 'text' (right click on cell and choose format cell)
Formula should look something like this:
=1+2
Check if there is whitespace before = sign of excel formula
35
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
