I typed in a formula but the results won't display. The text of the formula
actually displays. If I go into the formula editor I see the results of the
formula, so I know I typed it in correctly. How do I tell excel that I want
to see the results of the formula, not the formula itself?

letto115 Wrote:
I typed in a formula but the results won't display. The text of the
formula
actually displays. If I go into the formula editor I see the results
of the
formula, so I know I typed it in correctly. How do I tell excel that I
want
to see the results of the formula, not the formula itself?

Hi letto115

Try Tools Options View tab, under Window options uncheck the Show
Formulas box


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399078

"?B?bGV0dG8xMTU=?=" wrote in
:

I typed in a formula but the results won't display. The text of the
formula actually displays. If I go into the formula editor I see the
results of the formula, so I know I typed it in correctly. How do I
tell excel that I want to see the results of the formula, not the
formula itself?


Make sure the formula starts with = and set the cell format to General,
press F2 and Enter.


--

It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)

Hi,

Go to Tools / Options. Near the bottom of the Options window is a section
called Window Options. There is probably a check mark next to "formulas".
Uncheck that block.

Scott

"letto115" wrote:

I typed in a formula but the results won't display. The text of the formula
actually displays. If I go into the formula editor I see the results of the
formula, so I know I typed it in correctly. How do I tell excel that I want
to see the results of the formula, not the formula itself?