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

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

Sounds like the values are being imported as Text rather than numbers.
One way to convert:

Copy a blank cell. Select your "numbers" and choose Edit/Paste Special,
selecting the Values and Add radio buttons.




In article ,
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

That's brillaint, thanks to both of you, just what I wanted.

PD

"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