Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excell only displays the formula, not the results
Both the target cell a destination cell are formatted as general and unlocked.
I tried switching Formula auditing on/off, but nothing happens Now what? |
#2
|
|||
|
|||
Click in the cell, then:
<F2 <Enter If the formula was entered while the format was text, just changing the format to General or Number afterwards doesn't work. You have to re-enter the formula. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "René" wrote in message ... Both the target cell a destination cell are formatted as general and unlocked. I tried switching Formula auditing on/off, but nothing happens Now what? |
#3
|
|||
|
|||
All formulas begin with an "=" (without the quote marks).
=SUM() "RagDyeR" wrote in message ... Click in the cell, then: <F2 <Enter If the formula was entered while the format was text, just changing the format to General or Number afterwards doesn't work. You have to re-enter the formula. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "René" wrote in message ... Both the target cell a destination cell are formatted as general and unlocked. I tried switching Formula auditing on/off, but nothing happens Now what? |
#4
|
|||
|
|||
And if all the formulas show--but not the results, maybe you toggled:
Tools|options|View tab|uncheck formulas this can be toggled by hitting ctrl-` (control-backquote, to the left of the the 1/! on my USA keyboard) René wrote: Both the target cell a destination cell are formatted as general and unlocked. I tried switching Formula auditing on/off, but nothing happens Now what? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bold part of formula results | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Paste is is copying in formula, but display is wrong. | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |