The formatting doesn't matter. Have you tried the ISNUMBER() function? I'm
pretty sure that's the problem.
ToolsOptionsCalculation, Automatic checked?

--
Kind regards,

Niek Otten

"telewats" wrote in
message ...

I've tried both suggestions posted, however neither is working. After
trying the suggestions, I checked the formatting for the cells in
question, and they show to be number formatted, however I still get 0
when I sum them.


--
telewats
------------------------------------------------------------------------
telewats's Profile:
http://www.excelforum.com/member.php...o&userid=30270
View this thread: http://www.excelforum.com/showthread...hreadid=500378