Numeric Figures are not Recognised

The numbers are being imported into the spreadsheet as text not numbers.

If you try and do local calculation or format the cells as a number, the numbers will probably show with a proceeding quote mark indicating they are stored as text not as a number.

Note also the numbers are not aligning right.

When the quote mark is showing you can delete it to convert the cell to a number.

Or more efficiently you can use a spreadsheet function to convert the text to a number. See Copy and paste - #4 by Patch