Bryan Hessey wrote:
If you select (highlight) the columns into which you are pasting, and
Format Cells, set format to TEXT, and then Paste Special, Text your
cricket scores should remain intact.

I tried this yesterday without success and today it works fine! I must
have been doing something wrong!

Thanks.