Thanks very much Colin, that's very helpful.
I have actually turned off the error messages for numbers as text, as I'm often just wanting them as such, so that problem is sort of solved.

As for the first thing, I will have to read up on that, as I'm not so knowledgeable about pivot tables and suchlike.