Biplab Das
10

This Xls files convert digits of Rupees into words. Its very simple but effective. Hope it will helps for Rupees Conversion. Please give comments.
For the Interest of many People , I am attaching the unprotected files. Please give your valuable suggestion. ( It calculates below 99 Crores. But with some modification it will be calculate more than 99 Crores ..... )
All Minor Mistake was removed and Procedure to Set this conversion to your Xls Sheet is writiten in RupeeInWord(UnprotectedNew).xls . Please Download...... and share your comments..

From India, Kolkata
Attached Files (Download Requires Membership)
File Type: xls RupeeInWord.xls (32.5 KB, 16601 views)
File Type: xls RupeeInWord(Unprotected).xls (32.5 KB, 4371 views)
File Type: xls RupeeInWord(UnprotectedNew).xls (36.0 KB, 3443 views)

psdhingra
387

Dear Biplab,
It is really nice, but, its utility lies only when some one is able to incorporate the real formula in the excel sheet in his own documents. It won't provide any help to the community members if they have to write maually the amount in words in their invoices, payrolls or reports.
SO, BETTER GIVE THE EXCEL FORMULA TO PROVIDE REAL HELP TO MEMBERS.

From India, Delhi
konada67
Dear Mr. Das, Pl give the password of the file, so that the formula used can be shared. regards, K N RAO
From India, Secunderabad
hiyamedia
1

Good effort Das! but I still prefer the Add-in that puts all formulae in the VB Script and use it wherever needed.
From India, Mumbai
Attached Files (Download Requires Membership)
File Type: zip smb.xla.zip (8.0 KB, 1571 views)

Keshav Gupta
Dear Mr. Das
It is really a good one for conversion of numbers into words. Thanks for sharing the same with unprotected sheet. I have successfully converted my working sheet by using the various other formulas/links.
Thanks and regards
CS Keshav Lal Gupta

From India, Shimla
mantapurwar
It is very usefull for me, I was trying to find information like this, I have done little modification in your formula by adding "ONLY" in the end of sentence.
Thank You, Very Much Mr. Das
Naresh H. Mantapurwar
Amravati dist. Amravati.

From India, Amravati
prasad678
Dear Biplab, I find your spreadsheep very helpful, Many Thanks.
One more utility would be to give this in Millions and thousands as some of the US and Europe people are not very familiar with Lakh and crore.

From India, Hyderabad
arunignatiuj
1

Dear All, Kindly note down the code and apply in excel vba then only your problem will solve. Regards, J ARUN IGNATIUS
From India, Madras
santoshdurge
1

Dear Members,
The RSWORDS() function converts any number to currency in the form of words. This can be quite useful if you generate your invoices using Excel and you want the amount to be displayed in words.
I have attached one excel file namely Santosh Addin.xls. Please follow the below procedure to install the same.
How to install AddIns?
Installing AddIns in Excel is very simple.
1) First you save the attached Santosh Addin.xls on your computer.
2) Open Microsoft Excel.
3) Click on Tools>Add-Ins.
4) Click on Browse and navigate to wherever you saved the Santosh Addin.xls and then click OK.
5 You have installed the AddIn.
How to use it?
You can use Addins by directly entering the functions into a cell like =RSWORDS(XX) where XX is the reference of the cell you want to convert.
I hope it will be useful.
Regards,
Santosh

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: xls Santosh Addin.xls (43.5 KB, 5910 views)

Biplab Das
10

Thanks all the viewers/users . Its my satisfaction and also provide me more courage . One of my friend phoned me saying that 21 gives only "Hundred". Its a mistake when I typed data in Sheet1 Cell No.B21, Please check and type "Twenty One" in-place of Hundred". Some friend wants to add " Only ".And some of friend wants the procedure to add this conversion into their files. I am sharing this file again after necessary correction with procedure . Please give your valuable comments.
From India, Kolkata
Attached Files (Download Requires Membership)
File Type: xls RupeeInWord(Unprotected).xls (36.0 KB, 2469 views)

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.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.