Hi All

I've copied some data into Excel 2010 from HSBCnet and it has populated correctly. However, the numbers aren't being recognised as numbers by Excel meaning I can't use them in any mathematical formulas and when I highlight the cells I am not presented with a total amount, just a number telling me how many cells are selected. I have tried changing the format of the relevant cells from the regular 'format cells' menu but this hasn't helped.

Could anyone point me in the right direction on what to do?

Cheers

Steve