Ragdyer wrote:

Evaluates text:
=$M1="1"

That works a treat!

I have learnt a lot. So simple, but very important.

I have to convert the worksheet to text, other wise Excel converts data
like 9-2 and 5/1 to text.

Thanks so much.