Thanks guys

Using Whole numbers between 1 - 999999 does the trick



"Sally" wrote in message
...
,If you need 6 digits you data validation allow: whole number data:
between
minimum: 100,000 maximum: 999999. If less than 6 digits use less than
1,000,000
HTH
Sally
"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