ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

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

@VaibhavJ (Believe!! Live your dreams!)   (33496 Points)

29 December 2012  

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!!


 31 Replies

Saurabh Malpani (CA Final) (514 Points)
Replied 29 December 2012

 

#NAME?

 

@VaibhavJ (Believe!! Live your dreams!)   (33496 Points)
Replied 29 December 2012

Originally posted by : Saurabh Malpani

 




#NAME?




 

Please enable macro..thanks!!

1 Like

Dhanya Sreedhar (CA final, doing Job) (661 Points)
Replied 29 December 2012

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

geetha (student) (394 Points)
Replied 29 December 2012

thank u , it was easy .. yes

manoj (student) (5193 Points)
Replied 30 December 2012

GOOD ONE VAIBHAV

1 Like

Ramesha.M (Accountant) (800 Points)
Replied 31 December 2012

Dear Brother 

 

Working your formula 

Good Work

Thank you so much for sharuing

 

Best Regards

Ramesha.M

1 Like

manoj kumar (student) (41 Points)
Replied 31 December 2012

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

@VaibhavJ (Believe!! Live your dreams!)   (33496 Points)
Replied 31 December 2012

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!!

Chintan (C.A) (133 Points)
Replied 31 December 2012

Originally posted by : Dhanya Sreedhar

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

sagar (Credit procssing associate)   (51 Points)
Replied 03 January 2013

there is showing error #name after enable micro......pls help

@VaibhavJ (Believe!! Live your dreams!)   (33496 Points)
Replied 03 January 2013

Originally posted by : raju

there is showing error #name after enable micro......pls help

Press F9 key to calculate formula.

 

Thanks!!

sagar (Credit procssing associate)   (51 Points)
Replied 03 January 2013

Sir, pls tell me steps for enble to micro......

thanks

 

@VaibhavJ (Believe!! Live your dreams!)   (33496 Points)
Replied 03 January 2013

Hi

 

  1.  Click the Microsoft Office Button Button image, and then click Excel Options.
  2.  Click Trust Center, click Trust Center Settings, and then click Macro Settings.
  3.  Click the options that you want:
    •  Disable all macros without notification Click this option if you don't trust  
    • macros. All macros in documents and security alerts about macros are disabled. If there are documents with unsigned macros that you do trust, you can put those documents into a trusted location. Documents in trusted locations are allowed to run without being checked by the Trust Center security system.
    • Disable all macros with notification This is the default setting. Click this option if you want macros to be disabled, but you want to get security alerts if there are macros present. This way, you can choose when to enable those macros on a case by case basis.
    • Disable all macros except digitally signed macros This setting is the same as the Disable all macros with notification option, except that if the macro is digitally signed by a trusted publisher, the macro can run if you have already trusted the publisher. If you have not trusted the publisher, you are notified. That way, you can choose to enable those signed macros or trust the publisher. All unsigned macros are disabled without notification.
    • Enable all macros (not recommended, potentially dangerous code can run) Click this option to allow all macros to run. This setting makes your computer vulnerable to potentially malicious code and is not recommended.
    • Trust access to the VBA project object model    This setting is for developers and is used to deliberately lock out or allow programmatic access to the VBA object model from any Automation client. In other words, it provides a security option for code that is written to automate an Office program and programmatically manipulate the Microsoft Visual Basic for Applications (VBA) environment and object model. This is a per user and per application setting, and denies access by default. This security option makes it more difficult for unauthorized programs to build "self-replicating" code that can harm end-user systems. For any Automation client to be able to access the VBA object model programmatically, the user running the code must explicitly grant access. To turn on access, select the check box.

 TIP   You can open the macro security settings dialog box from the Developer tab in the Ribbon, which is part of the Microsoft Office Fluent user interface. If the Developer tab is not available, click the Microsoft Office ButtonButton image, and then click Excel Options. Click Popular, and then select the Show Developer tab in the Ribbon check box.

Pl refer link: https://office.microsoft.com/en-in/help/enable-or-disable-macros-in-office-documents-HA010031071.aspx

Select Second last oprion.

Thanks!!

 

jafer (studies) (194 Points)
Replied 09 January 2013

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


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  


Related Threads


Loading



Subscribe to the latest topics :
Search Forum:

Trending Tags