T
tdekker
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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.
displays only the formula.
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.
formatting the cell in a number of ways: General and Number. It stilltdekker said:I am an experienced user. Yes, the equal sign is there. I have tried
displays only the formula.
D
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Number. It still displays only the formula.tdekker said:I am an experienced user. Yes, the equal sign is there. I have tried formatting the cell in a number of ways: General and
D
Dru
have you tried
Ctrl -
Ctrl -
G
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.
displays only the formula.
Tools>Options>View> WindowsOptions: "Formulas" got checked accidentally? It
will display all formulas
--
George Nicholson
Remove 'Junk' from return address.
formatting the cell in a number of ways: General and Number. It stilltdekker said:I am an experienced user. Yes, the equal sign is there. I have tried
displays only the formula.
D
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.
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.