If your suspect value is in A2, look at =ISTEXT(A2) and =ISNUMBER(A2)
--
David Biddulph


"Jenny Beech" wrote in message
...
I checked the calculation mode and it is automatic.

How do I know if the values are real numbers?

"Gary''s Student" wrote:

Sounds like your values are not "real" numbers. They may be Text values.
Another possibility is you may be in manual calculation mode.
--
Gary''s Student - gsnu200908


"Jenny Beech" wrote:

I am using 2007 and I have a workbook that returns a "0" instead of the
actual sum. I have tried using @sum formula and just adding the cells
together.

Any ideas??