Excel question

[BenElliottRacing]

Writing up my accounts and have a snag.

I have copied my bank statements across from web page onto excel spreadsheet. Now that I want to try and do some sums with the columns they are all totalling 0.

If I retype a figure then the sum at the bottom goes up by that amount.

Short of retyping every figure in 9 months of bank statements how can I get excel to see the pasted text as numbers?

Tried converting all fields to 'number' but no success. Spent a bit of time on help but couldn't find anything useful.

TIA

[BenElliottRacing]

Tried that. Used to bank with Natwest so went looking for the download option. Am now with HSBC which gives you a print option but little else.