Cannot get data to do a sum total

I received an Excel file where I need to find the sum total for a column. But the cell format is displayed as “text” so I change it to the number format. When I do an AutoSum nothing happens. I even tried to copy the data to a new worksheet and do a Paste Special and again I get no total. How do I get the data to show the sum total?