If it was text formatting simply changing it back to number formatting won't
make a difference, you need to trigger a calculation to get it to work and
that's what I suggested in my answer to your post


--
Regards,

Peo Sjoblom



"Jimi" wrote in message
...

Thanks Bob, but thats not it.
Its strange. Played with the formatting in several ways, no luck.
It seems to happen anywhere on the spreadsheet - cant input new formulae!

"Bob Phillips" wrote:

Sounds like the cells are formatted as text. Change that and it should be
okay.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Jimi" wrote in message
...
problem with entering new formulae. I want to sum cells w45 and x44,
and
subtract cell x45. When I enter it the formulae looks right but the
value
comes up as 0 whenit is not.
on another worksheet, this works. On this new one it doesnt, so its
like a
format thing or whatever. I haev tried =sum(w45+x44-x45) also =
w45+x44-x45,
and other ways - no luck.