Excel file to check whether pan no. is valid or not


Believe!! Live your dreams!

Hi,

 

I have made a PAN checking function in excel.

 

This will check whether PAN no. supplied is correct ot not.

 

To check this in cell type formula =ispanvalid(A1)

where A1 is cell reference in which pan no. is typed.

 

https://docs.google.com/open?id=0B7i2wkMBVw9xQ2ZYekJKUUVqWFU

 

Also make sure that your MACRI is enabled.

 

Pl check & confirm about the functioning of the same & error if any.

Thanks!!


Total likes : 7 times

 
Reply   
 

 

#NAME?

 

 
Reply   
 
Believe!! Live your dreams!

Originally posted by : Saurabh Malpani

 




#NAME?




 

Please enable macro..thanks!!


Total likes : 1 times

 
Reply   
 
CA final, doing Job

Its working....Nice one...Thanks for sharing smiley  yes

 
Reply   
 
student

thank u , it was easy .. yes

 
Reply   
 
student

GOOD ONE VAIBHAV


Total likes : 1 times

 
Reply   
 
Accountant

Dear Brother 

 

Working your formula 

Good Work

Thank you so much for sharuing

 

Best Regards

Ramesha.M


Total likes : 1 times

 
Reply   
 

Vaibhav ,How can we use it.

shall i have to do any setting in my excel.

I have Excel 2007

My mail id is kumarmanoj258 @ gmail.com

 
Reply   
 
Believe!! Live your dreams!

Originally posted by : manoj kumar

Vaibhav ,How can we use it.

shall i have to do any setting in my excel.

I have Excel 2007

My mail id is kumarmanoj258 @ gmail.com

you can use formual only in this workbook..

You have to enable macro so as to function work..

pl let me know if youi wish to make it default for all!!

Thanks!!

 
Reply   
 

Originally posted by : Dhanya Sreedhar

Its working....Nice one...Thanks for sharing   

 
Reply   
 

LEAVE A REPLY

Your are not logged in . Please login to post replies

Click here to Login / Register  

 


×

  CCI MENU