See if this works:

Select the single-column range of "numbers" (eg A2:A100)

From the Excel main menu:
<data<text-to-columns....click [Finish]

Does the sum function return the correct value now?
***********
Regards,
Ron

XL2003, WinXP


"Jenn" wrote:

I have a column of 722 numbers and I want to add them but when I click the
sum function and select all the cells it returns with a 0. I have made sure
they are numbers, have tried to copy and paste to a different worksheet but
it is all coming out the same. I've even tried to do it with just a couple
numbers in the column and it still says 0.

But, if I type in numbers the sum function works perfectly.