Try this:
DataValidation
Allow: Whole Number
Between 111111 and 999999

Does that do what you want?

***********
Regards,
Ron


"John" wrote:

I require a Data Validation that will only allow up to 6 digits to be
inserted. This can only allow digits 1 - 9 as any one of the 6 digits.

I've tried Text Length, but that allows characters - / T etc

Any ideas?

Thanks