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

Page no : 2

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 09 January 2013

Originally posted by : jafer
	Hi sir, It is saying total charactor is 11 but i actually entered 10 digits only. can u exactly tell me where i have to put my pan no.? thanks in advance. regards, Jafer

hey plz retype agn all 10 char in cell..

there will be hidden character because of that you are getting this error!!

Thanks!!

Upgrade to CAclubindia Pro. Subscribe Now!

Gurupal Singh (Accountant) (33 Points)
Replied 12 July 2013

Showing #Name? ......... i have enabled MACRO .. still getting errors

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 13 July 2013

Originally posted by : Gurupal Singh
	Showing #Name? ......... i have enabled MACRO .. still getting errors

Hey make sure you have spelled ispanvalid correctly.

Thanks!!

Hitesh (Accountant) (25 Points)
Replied 17 September 2013

Vaibhav, How can we use it ? What are macros ? How to record macros ? What I have to do for that ? I am having Excel 2007.

My mail id is <ht9026 @ gmail.com>

Please reply .. Thanks

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 17 September 2013

Hi,

you can know about macro from following URL:

https://www.wikihow.com/Write-a-Simple-Macro-in-Microsoft-Excel

https://www.howtogeek.com/162975/geek-school-learn-how-to-use-excel-macros-to-automate-tedious-tasks/

Thanks

Upgrade to CAclubindia Pro. Subscribe Now!

sandeep jain (Finacial Advisor) (34 Points)
Replied 26 October 2013

gud 1 vaibhav

but i found 1 error for PAN No.- AAGCM5406K, its showing False, but its a Valid Pan no.

Plz expln

Regards

Sandeep jain

1 Like

@VaibhavJ (Believe!! Live your dreams!) (33516 Points)
Replied 26 October 2013

@ Sandeep try this attached file!

Thanks//Vaibhav

Attached File : 112266 1243338 pan validation ver 5 00 rev for all.xls downloaded: 517 times

Mohammad Junaid (2 Points)
Replied 05 January 2017

Its not working. I have enabled the developer option but everytime i put enter on function or run macro. it ask for a seleium driver.

Legistify (33 Points)
Replied 11 January 2017

Hi,

We would be happy to understand your legal concern in detail and help you out.

At Legisitfy, we want to make legal easy, fast and simple and most of all approachable by making it available to more people than ever before.

Whether you need to find a lawyer, consult or get a quote you can find it all at Legistify.com. So if you need a lawyer or legal advice we are here:) Visit Legistify.com/consult or you can reach us at +919250004781, +91-9250004782.We would be happy to offer you 30 min free legal advice.

If you think Legistify could help any of your friends or family, please share with them too. Let’s make law easy for everyone around.
For anything legal…Legstify it.

Cheers!
Team Legistify

Contact : +919250004782/+919250004781 Or

Visit : www.legistify.com/#

Anubhav Gupta (Accountant) (33 Points)
Replied 27 January 2017

Dear Friends,

Here I am sharing with you my PAN no verification Excel file. Just enter your PAN in PAN no coloumn in capital letters you get the result. You check 100 PAN at a time.

If any query plz reply to me.

Attached File : 1209276 20170127155548 pan no verifcation.xlsx downloaded: 317 times