Convert A Number Into Text Format - Zip Download

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

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.

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,

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

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

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

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.

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)

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

Kindly Explain How to add your tools into Excel add ins