My guess is that the numbers are actually text.

Try this........................

Format all to General.

Copy an empty cell.

Select the range of data and EditPaste SpecialAddOKEsc


Gord Dibben MS Excel MVP

On Thu, 2 Aug 2007 11:44:04 -0700, Jimi wrote:

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.