Bob Phillips wrote:
Use Data Validation with a type of whole number and values of 1111111
and 9999999
Surely it'd need to be 1000000 to 9999999 otherwise 1023456 for instance
would not be valid.