Thank you all for your suggestions and advice.

Being an engineer, I have dumped the offending sheet/page
and started with a fresh one that works as it should.

I am still confused with the faulty sheet and cannot think
how such an error can happen, I could understand a cash
sum being wrong, but not a date over 100 years popping up.

Thank you once again.

Mike.