Thank you, that seems to work. The big question is why?



I am going to apply this to other programs to see how they react.

Thanks again for sticking with this, much appreciated.

I suspect it's because, when the formula saw the 2017 in the IF test, it treated the whole thing as if it was looking for just the number. Replacing the 2017 with ???? causes Word to look at the rest of the expression as well.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]