Prev: Linking multiple databases to one summary page
Next: apply/erase formatting, clear content, ...
From: Ashley on 17 May 2010 16:16
Sometimes when I enter a formula into an Excel cell, the formula itself is
displayed in the cell instead of the formula result. However, when I open
Formula Wizard, the Wizard shows the correct formula result that should be
displayed in the cell. Why does this happen and how do I get it to stop
happening?
From: T. Valko on 17 May 2010 16:32
It sounds like the cell is formatted as TEXT.

Change the cell format to General. Then, with the cell still selected hit
function key F2 then hit Enter.

--
Biff
Microsoft Excel MVP


"Ashley" <Ashley(a)discussions.microsoft.com> wrote in message
news:6DE41209-EE18-4E7E-848B-FB1E09186B80(a)microsoft.com...
> Sometimes when I enter a formula into an Excel cell, the formula itself is
> displayed in the cell instead of the formula result. However, when I open
> Formula Wizard, the Wizard shows the correct formula result that should be
> displayed in the cell. Why does this happen and how do I get it to stop
> happening?


From: Dave Peterson on 17 May 2010 16:45
Or you could be looking at formulas

In xl2003 menus:
tools|options|view tab|uncheck formulas

(It's under the Office Button|Excel options (somewhere) in xl2007.)

Or you can use:
ctrl-` (ctrl-backquote (the key to the left of the 1/! on my USA keyboard) to
toggle this setting in any version of excel.

On 05/17/2010 15:16, Ashley wrote:
> Sometimes when I enter a formula into an Excel cell, the formula itself is
> displayed in the cell instead of the formula result. However, when I open
> Formula Wizard, the Wizard shows the correct formula result that should be
> displayed in the cell. Why does this happen and how do I get it to stop
> happening?
 | 
Pages: 1
Prev: Linking multiple databases to one summary page
Next: apply/erase formatting, clear content, ...