Thank You - works perfectly - you deserve the MVP.

"JohnButt" wrote:

I have a column named PTS Number
I have used the custom validation to ensure that duplicate values are not
repeated.
Is there a way of combining the COUNTIF formula to ensure that at least 6
numeric characters are imputed?