SUM figures from converted CSV file to .xlsx file

I have downloaded a bank statement and converted it from a .csv file to a to .xlsx file.  I have changed the format of the cells to "number" but the SUM Function does not work and just returns a Zero...