Thread: How to validate a cell to insert from 9 digit number to 13 digit number.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to validate a cell to insert from 9 digit number to 13 digit n
Data Validation Settings Allow Text Length Betweem 9 and 10
--
Gary''s Student
gsnu200707


"ramulu via OfficeKB.com" 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.

--
Message posted via http://www.officekb.com


Reply With QuoteReply With Quote