Formulas

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

[Paul Sheppard]

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

[Dodo]

"=?Utf-8?B?bGV0dG8xMTU=?=" <[email protected]> wrote in
news:[email protected]:

> 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)

[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

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