Hi Pawan
good work, I have also written a user defined function in excel which does the same.
In addition to guide lines provided above to CiteHRusers one may also note that, the file provided by Mr Pawan is an addin which can be stored in excel's startup folder. By storing like that you need not open the provided file every time. Excel will open the file at the backend every time excel program is opened.
You need to just type function name like
=RsWord(1245)
=RsWord(cell address or cell link)
However users cannot share the file with the others/or function formula in the file cannot be used in the other systems as it will give error#
If anybody wants to share the file with other users or files are frequently exchanged between users for for reporting purpose they can copy the fucntion written in the original addin file to the VBA module of such excel file. However one need to enable macros in order to use this customised function.
Thanks Regards
Ramesh Shetty
Quote:
Originally Posted by pawan_malik  Hi! Madhu,
I have already create it. mail me at  if u really want to receive it, because I have done some programming on it & don't want to share it on this site.
I would like to inform all of the process:-
1.) Open the file received by you.
2.) You will find the blank excel file now go the File menu-> open -> open your desired file.
3.) Now you will find your original excel file.
3.) Select the cell where you want the result in format.
4.) go to formula section & select category as user defined (This is a new formula) & select RsWord than click on ok button now select the number by mouse click on excel sheet now click ok button.
Hope you will find your desired result.
Please don't forget to reply if u are satisfied.
Also share your comments.
Pawan Kumar |
