One possibility:

There may leading/trailing spaces in your data. This makes the data TEXT.
When you manually retype the number you're not including those spaces.

Biff

wrote in message
oups.com...
Hey, Group:

I'd trying a simple sum formula on cells that already have existing
numbers. The formula is only reporting 0 when I try adding the cells
together, but if I change the cells value, the formula will start to
add the changes, but no existing numbers.

Versions: All
Worksheet: contains 15 columns and 950 linees
Other: All cells are type of general.

Kinda vague, but hopefully enough.

Thanks,

--TJ