My bank has recently changed its website presentation.

I normally copy and paste data from my web bank account page into an excel
spreadsheet. The data in three columns contains date, text, and amounts in
numbers. Now however, I can format layout, text etc but for some reason the
date cells cannot be formatted nor can the numbers be added to give a total.

The cells seem to be "inert". Is there a way of rectifying this within Excel??