cells displays formula, not result

[Guest]

I am an experienced user. Yes, the equal sign is there. I have tried formatting the cell in a number of ways: General and Number. It still displays only the formula.

 

[Andy B]

Hi

A couple of suggestions. Calculate could be set to automatic or maybe the
cell was formatted as text before you typed the formula in.

Andy.

I am an experienced user. Yes, the equal sign is there. I have tried

formatting the cell in a number of ways: General and Number. It still
displays only the formula.

 

[David McRitchie]

and of course Calculation is on, and F9 doesn't change anything.

Perhaps you have spaces or Char(160) in the formulas, as if
they had been copied from a web site.
Determine if cell is Number or Text and why is it seen that way (#debugformat)
http://www.mvps.org/dmcritchie/excel/join.htm#debugformat

TrimALL macro (#trimall)
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

I am an experienced user. Yes, the equal sign is there. I have tried formatting the cell in a number of ways: General and

Number. It still displays only the formula.

 

[Dru]

have you tried

Ctrl -

 

[George Nicholson]

Is this just one cell where this is happening? Any chance that
Tools>Options>View> WindowsOptions: "Formulas" got checked accidentally? It
will display all formulas

--
George Nicholson

Remove 'Junk' from return address.

I am an experienced user. Yes, the equal sign is there. I have tried

formatting the cell in a number of ways: General and Number. It still
displays only the formula.

 

[Dave Peterson]

If the cell were formatted as text before you typed the formula, then just
changing the format to General won't fix it.

You have to change it to general and then make a change to it (or just hit
F2|Enter to pretend to make a change).

If you have lots (like a whole column), you can reformat the column to General

and then Edit|replace
=
with
=

And excel will reevaluate the formulas.