Forum Discussion

Bert Estrada's avatar
Bert Estrada
Copper Contributor
Sep 25, 2018

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.

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Sep 25, 2018
    Select the numbers which Excel seems to treat as text. From the Data Tab, choose Text to Columns. Click Finish.

Resources