Number convert into Text Format

pawan_malik · #1 21-03-2009, 03:10 PM

Dear All,

For a long time I am searching a command by which I can convert Rupees value from a number to a text format.

For Example:
Digit Value : Rs. 4196.00
Text Value : Rupees Four Thousand One Hundred Ninty Six Only.

If you really need it please send your mail ids on my personel Id as I can't attach it here.

Thanks,

Pawan Kumar
Executive HR

****Dear All as per the requirement in a large number I am attaching this file here, so please download it.

Thanks,

Pawan Kumar

hr770 · #2 21-03-2009, 03:50 PM

Dear pawan

i have done same research on same process but till i din't get it , i appreciate u, keep searching and plz update me when u get that .................

Regards
madhu Gupta

chandra Bhushan Sharma · #3 21-03-2009, 04:00 PM

Dear Pawan,

Could you please send me the same to my email Id :

Thanks n Regards,

C. Bhushan Sharma

pawan_malik · #4 21-03-2009, 04:03 PM

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

Puttapudi Venkateswara Ra · #5 22-03-2009, 04:03 PM

dear pawan

plse mail this to me...................id is :

thanks in advance.

raju41 · #6 22-03-2009, 04:22 PM

dear mr.pavan kumar
please e mail me the process soft ware to address

. many thanks for your research, which is what needed in the hour.

raju41 · #7 22-03-2009, 04:24 PM

dear mr.pavan kumar
sorry,while typing the e mail address shown was wrong. now i am sending with correct address/
please e mail me the process soft ware to address

. many thanks for your research, which is what needed in the hour.

Kanak · #8 22-03-2009, 05:43 PM

Dear Pawan,

Please forward me on my personal email id

Regards,
Ashvini

Quote:

Originally Posted by pawan_malik

Dear All,

For a long time I am searching a command by which I can convert Rupees value from a number to a text format.

For Example:
Digit Value : Rs. 4196.00
Text Value : Rupees Four Thousand One Hundred Ninty Six Only.

If you really need it please send your mail ids on my personel Id as I can't attach it here.

Thanks,

Pawan Kumar
Executive HR

Anamika Guglani · #9 22-03-2009, 07:43 PM

kindly send me at

Regards

pksrivastava79 · #10 22-03-2009, 08:25 PM

hi,
pls mail me at