Open attachment and enjoy by convert Rupees value from a number to a text format. Click on enable macros.
For Example:
Digit Value : Rs. 4196.00
Text Value : Four Thousand One Hundred Ninty Six rupess
Jitendra Patel
Gozaria
Gujarat
Email -

From India, Mahesana
Attached Files (Download Requires Membership)
File Type: xls jitu excel convert sheet108.xls (59.0 KB, 5939 views)

hi all,
i want to convert number to word by indian method
for Eg, if i want to convert 124560.25 is Rupees one lakh twenty four thousand five hundered and sixty and twenty five paise only
if any body having the formula.please forward me to
thanking you in advance
regards
mubarak


Dear All, PLz Find The Excel Sheet. After enable the macro there is a function Spellnumber that will convert From number two Cur. Ex=spellnumber(123) result=Rupees One Hundred Twenty Three Only
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls SpellNumberFunction.xls (66.5 KB, 2435 views)

Mr.Nirbhay Singh
do have the sheet which convert numbers to words. for eg, RS.10025.25 by Rupees ten thousand and twenty five and twenty five paise. if you have please forward my email:smubarak_1983@hotmail.com
Thankis in advance
regards
mubarak


Hi, Please find the attached Excel Sheet. It will convert the currency to number format upto 99,999 in normal Excel sheet without Macros. I have written the formula. Suggestions/advice are welcome.
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Curreny to Word.xls (34.0 KB, 1691 views)

Thank you Mubarek.
I will definetely try and once i get it i will post it.
Hi aswin. Just download the document and you can see the query to convert the number into text format which you can copy and paste anywhere

From India, Hyderabad
Dear All,
Use The Excel Sheet Posted By Me it will Converd UPTo 999999999 digit
ex-
=spellnumber(999999999.25)
Rupees Ninety Nine Crores Ninety Nine Lakhs Ninety Nine Thousand Nine Hundred Ninety Nine and Paise Twenty Five Only

From India, Bangalore
Here is the attachment. Please see. There may be some mistakes.
From India, Hyderabad
Attached Files (Download Requires Membership)
File Type: xls Curreny to Word[1].xls (36.0 KB, 985 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.