How to validate a cell to insert from 9 digit number to 13 digit number.
 

hi everybody,

There is a need to validate a cell to insert only from 9 digit number to 13
digit number.

For Example: 000000001 to 9999999999999. ( I want to ristrict the
user to enter even 8 digit number i.e. 99999999)



Thanks.

How to validate a cell to insert from 9 digit number to 13 digit n
 

Select the cells, go to Data/validation, seleect text length and add minimum
9 and maximum 13
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"ramulu" wrote:


hi everybody,

There is a need to validate a cell to insert only from 9 digit number
to 13
digit number.

For Example: 000000001 to 9999999999999. ( I want to ristrict
the
user to enter even 8 digit number i.e. 99999999)



Thanks.




--
ramulu