ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excell only displays the formula, not the results (https://www.excelbanter.com/excel-discussion-misc-queries/2590-excell-only-displays-formula-not-results.html)

René December 28th 04 09:21 AM

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?

RagDyeR December 28th 04 10:37 AM

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?



Jim May December 28th 04 02:24 PM

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?





Dave Peterson December 28th 04 03:08 PM

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


All times are GMT +1. The time now is 04:50 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
ExcelBanter.com