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

  • Thread starter ramulu via OfficeKB.com
  • Start date
R

ramulu via OfficeKB.com

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to validate a cell to insert from 9 digit number to 13 digit number. 1
How can i copy a 16 digit number to excel from another software(HT 2
Need to extract specific data from a text column 2
Display entire number in cell 3
? Link attached - How to validate SIN (Social Insurance Number) 5
cell data = "Schedule from " & A3 where A3 is a date. 1
Converting a cell value 4
Change a 1,2,3 or 4 digit number to a 6 character text string 3

Top