Try Highlighting the column and selecting Data Text to columns then
hitting the finish button in the pop up box

"JoeD" wrote in message
...
I have imported data from a web query into an Excel worksheet. I am
trying
to add the totals of a column (SUM). My formula in cell A10 is:
=SUM(A1:A9).
The result displayed in A10 is 0.

When I select cell A1 it's data is displayed in the formula bar, with an
additional space on the left side of the data. If I remove the space
(delete
key), the SUM function will add just that cell. If I remove the 'space'
from
in from of each entry in the column, the SUM function works fine.

I've tried the tools, options,calculation, automatic settings, but that
does not help. I've tried to "indent" or shift the entire column over,
but
neither worked.

Anyone have a suggestion?

Thanks for your time.