@VaibhavJ (Believe!! Live your dreams!) 29 December 2012
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.
Also make sure that your MACRI is enabled.
Pl check & confirm about the functioning of the same & error if any.
CAclubindia Online Learning offers a wide variety of online classes and video lectures for various professional courses such as CA, CS, CMA, CISA as well as various certification courses on GST, Transfer Pricing, International Taxation, Excel, Tally, FM, Ind AS and more. know more
@VaibhavJ (Believe!! Live your dreams!) 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!!