Forum Discussion
auto sum
Trying to use AutoSum to add numbers in a column. the AutoSum result keeps coming up as 0. For some reason it will not recognize the numbers and add they up.
Select the numbers which Excel seems to treat as text. From the Data Tab, choose Text to Columns. Click Finish.