That was about the second or third thing I tried. The cell was set to Text
while it was blank and I have heard that formats set on blank cells tend to
'stick' even though one changes the format.

regardless of whether the cell is formatted as text though, the '=' sign
should override that, right? At least it always has. It certainly seems odd
that anyone would consider the current state of affairs an improvment.

This seems like a very, very bad thing to do .

"Gary''s Student" wrote:

If you enter a formula in a cell and the formula appears in both the cell and
the formula bar, the usual cause is that the cell was formatted as Text
before the formula was entered. Clear the cell (both contents and format)
and then re-enter the formula.
--
Gary''s Student - gsnu200906


"BS" wrote:

We recently upgrade to Office 2007. I have used Office products since 1995
and am a developer.

Often when I enter a formula in a cell, say: =IF(ISNUMBER(G2),0,1), the
expression is treated as though it were a string. There is no leading quote
and no result.

what is up?