Is there a way of combining the COUNTIF formula to ensure
that at least 6 numeric characters are imputed?

What is the format of these 6 numbers? Will there be any leading 0s? Is this
a legitimate number: 000000 ?

--
Biff
Microsoft Excel MVP


"JohnButt" wrote in message
...
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?