Wont Sum

P

Phil

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
 
M

Max

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.
 
J

JE McGimpsey

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.
 
Top