Wont Sum
 

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

Wont Sum
 

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

Wont Sum
 

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

Wont Sum
 

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