Thanks for the response and the welcome!

Indeed it was something silly. I have overcome this by formatting cell C13 also as text which has solved the problem.

I stored the numbers as text as this stops it from omitting the 0 from numbers that begin with 0. Is there a way to stop this so that they can be treated as a number?