G
Guest
I am trying to put formulas in my worksheet, and I get the formula displayed in the cell but not its value. How do I change this? Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Max
A couple of quick diagnostics:
You might accidentally be in Formula view ?
Try pressing CTRL + ~
[ ~ is the tilde key, just above Tab key, to the left of "1" key ]
This key combo toggles the Formula view on / off
Just hit the key combo again to toggle it back to off.
Or, click Tools > Options > View tab
Under "Window options" - ensure "Formulas" is unchecked > OK
--
Check also that the cell is not inadvertently formatted as "Text"
Re-format as General
--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
You might accidentally be in Formula view ?
Try pressing CTRL + ~
[ ~ is the tilde key, just above Tab key, to the left of "1" key ]
This key combo toggles the Formula view on / off
Just hit the key combo again to toggle it back to off.
Or, click Tools > Options > View tab
Under "Window options" - ensure "Formulas" is unchecked > OK
--
Check also that the cell is not inadvertently formatted as "Text"
Re-format as General
--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
displayed in the cell but not its value. How do I change this? Thanks!clane said:I am trying to put formulas in my worksheet, and I get the formula
J
JJ
you may have entered the formula in "text" format
do I change this? Thanks!
the formula displayed in the cell but not its value. How-----Original Message-----
I am trying to put formulas in my worksheet, and I get
do I change this? Thanks!
D
Dave Peterson
And if you did have the cell formatted as text, you'll have to reenter the
formula.
(F2 followed by an enter will suffice)
formula.
(F2 followed by an enter will suffice)
A couple of quick diagnostics:
You might accidentally be in Formula view ?
Try pressing CTRL + ~
[ ~ is the tilde key, just above Tab key, to the left of "1" key ]
This key combo toggles the Formula view on / off
Just hit the key combo again to toggle it back to off.
Or, click Tools > Options > View tab
Under "Window options" - ensure "Formulas" is unchecked > OK
--
Check also that the cell is not inadvertently formatted as "Text"
Re-format as General
--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
displayed in the cell but not its value. How do I change this? Thanks!clane said:I am trying to put formulas in my worksheet, and I get the formula