Formulas

L

letto115

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?
 
P

Paul Sheppard

letto115 said:
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?
Click to expand...

Hi letto115

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

Dodo

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?
Click to expand...

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

Scott Summerlin

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
 
Top