Probably text numbers. One way to convert these to real numbers, just copy a
blank cell, then select the range of "numbers", right-click paste special
check "Add" ok. The SUM should work now.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Phil" wrote:
Hi there,

Hope someone can help with a odd problem that I have, I am returning some
rows from a SQL database with a column of numbers (int values), but for some
reason when they appear on the Excel sheet, I cannot Sum the values, I just
keeping getting 0 when I can clearly see numbers to SUM.

Any advice would be great, Thanks PD