string - AutoSum and Sum return '0' when trying to add numbers imported by SQL -

excel 2007 - anytime click autosum shows 0, or anytime use formula sum still gives me 0.

this sql query imported using data-connection-sql server , saved sql query in workbook.

what gives keeping me totalling?

it seems me explanation trying add strings. if so, error checking activated (formulas tab) little triangles (by default green) should clear evidence.

these provide easy way convert strings numbers numbers excel can add. select contiguous range starting cell requiring conversion , warning sign should appear:

(not top left). click on exclamation mark , on convert number , format of cells in selection converted sum function behave like.

much less (because don't see how have done) somehow have acquired leading spaces , when entering data cell formatted text. triangle warning same number stored text no conversion. formula such as:

=trim(a1)    

should however, though depend on type of space (eg not work nbsp - though should not acquire 1 of sql import).

there may other possible causes seems best try above before alternatives.