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.