Scott

A good bet is the numbers are text that look like numbers.

Re-formatting alone won't change that.

Format all to General then copy an empty cell.

Select the range of data and EditPaste Special(in place)AddOKEsc.

This will force Excel to recognize these as numbers.............if there are no
extra spaces or other junk in the cells.


Gord Dibben MS Excel MVP

On Mon, 8 Jan 2007 14:23:02 -0800, Scott
wrote:

Hello,

I have a SUM( ) formula that is not working. The number format is "General
(not text)." I have also manually recalculated but I'm still getting a zero
for the total. Any ideas?

Thanks,
Scott