Dear All,
As per the requirement by all of you I am attaching this file because it is not possilbe to me to reply all of you.
So please download the attached file for you own use.
Thanks,
Pawan Kumar
HRD
From India, Delhi
2As per the requirement by all of you I am attaching this file because it is not possilbe to me to reply all of you.
So please download the attached file for you own use.
Thanks,
Pawan Kumar
HRD
From India, Delhi
Press ALT+F11 on Excel then goto Modules below on left and paste the notepad text attached here. then in formula for cell type =ntow(cellreferance) [e.g. =ntow(A2) or = ntow(4168 ). Thats it.
From India, Mumbai
From India, Mumbai
Hi Pawan,
Good work.
I have easy method of using this file. Here it goes:
1. save the file on desktop.
2. From your excel, go to tools-> Options -> Add-ins
3. Select Browse. Now you will directly taken to the Add-ins folder
4. Here u paste the file u saved.
5. Now this addin is automatically selected by excel, if not pl check box the addin "Rswords".
6. Now u can easliy use the formula in any excel worksheet, by just giving the formula "=rswords(cell reference or value)".
Note: This works only on machines in which you have this add-in. So pl ensure before sending the file saved on your computer with this formula to another machine also has it. Else the result on the other computer will not be shown.
Thanks pawan for the file.
Regards,
From India, Hyderabad
Good work.
I have easy method of using this file. Here it goes:
1. save the file on desktop.
2. From your excel, go to tools-> Options -> Add-ins
3. Select Browse. Now you will directly taken to the Add-ins folder
4. Here u paste the file u saved.
5. Now this addin is automatically selected by excel, if not pl check box the addin "Rswords".
6. Now u can easliy use the formula in any excel worksheet, by just giving the formula "=rswords(cell reference or value)".
Note: This works only on machines in which you have this add-in. So pl ensure before sending the file saved on your computer with this formula to another machine also has it. Else the result on the other computer will not be shown.
Thanks pawan for the file.
Regards,
From India, Hyderabad
nice effort by pawan. Guys i know a addin extool I have been using for more than 2 + yrs. very useful as it has automated many such features including one given by Pawan and besides it free. It just asks you to donate some money you want to their site if you find it useful.
Free Microsoft Excel add-in download - Excel spreadsheet free downloads and Excel VBA tools
Free Microsoft Excel add-in download - Excel spreadsheet free downloads and Excel VBA tools
its in the google its self, if you type suresh addin you can able to download the excel software and then you can add in in the excel in yopur desktop.Thanks & RegardsParthasarathy
From India, Madras
From India, Madras
Hi, Really Good One.... thnx for sharing..... I have saved an excel file with Password Secuirty... I forgot the password..... If possible plz help how to break password... Regards Imee
From India, New Delhi
From India, New Delhi
dear pawan, just i gone to the excel and also seen in the user defined of the function... there is no formula named rsword.. can you tell me on what version of excel is it available.
From India, Madras
From India, Madras
Hi All,
Just try this also I think something easy,
Just go any of excel sheet give any of number like 50, 60, 70 etc in one cell.
Go In next cell give this formula =rswords(select any cell) and enter.
=RsWords(F2)
From United States, Palo Alto
Just try this also I think something easy,
Just go any of excel sheet give any of number like 50, 60, 70 etc in one cell.
Go In next cell give this formula =rswords(select any cell) and enter.
=RsWords(F2)
From United States, Palo Alto
hi guys if i use this amount =rswords(22136.2) this how its comming on hundred and is not comming pls help me out or change the macro code plz
Rupees Twenty Two Thousand One Hundred Thirty Six And Paise Twenty Only
From India, Madras
Rupees Twenty Two Thousand One Hundred Thirty Six And Paise Twenty Only
From India, Madras
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
UAN KYC PF TEXT UPload Format.xls
Induction Training Text Format - Staff .doc
Process flow for Updation of Aadhar Number.pdf