Validating PAN NUMBER Indian Format

Hi,

How to use Data Validation on PAN NUMBER,

The cell should take only if it is in such format.

Hi

Welcome to board!!!

See http://www.excelfox.com/forum/f13/va...alidate+number

Quote:

---

Originally Posted by Admin

Hi

Welcome to board!!!

See http://www.excelfox.com/forum/f13/va...alidate+number

---

Hi,

if i use the formula that u have suggested shows an error like " You may not use unions, intersections, or array constants for data validation criteria "

What is the solution.

If the PAN is in A2, enter this formula in B2

=AND(COUNT(MID(A2,{6,7,8,9},1)+0)=4,COUNT(SEARCH(" ~"&MID(A2,{1,2,3,4,5,10},{1,1,1,1,1,999}),"ABCDEFG HIJKLMNOPQRSTUVWXYZ"))=6)

and in A2, use the DV formula as =B2=TRUE