If the numbers are text, it does no good to just re-format them to numbers.

You must get Excel to recognize them as numbers.

Format all to General.

Copy an empty cell.

Select the range of "numbers" and EditPaste SpecialAddOKEsc


Gord Dibben MS Excel MVP


On Thu, 2 Aug 2007 14:38:12 -0700, Jimi wrote:


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.