Open the attachment and convert the 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 Ninety-Six rupees

Jitendra Patel
Gozaria, Gujarat
Email: jitendra.teo@gmail.com

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

Acknowledge(1)
Amend(0)

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, 2436 views)

Acknowledge(0)
Amend(0)

Mr. Nirbhay Singh,

Do you have the sheet that converts numbers to words? For example, RS.10025.25 would be Rupees ten thousand and twenty-five and twenty-five paise. If you do, please forward it to my email: smubarak_1983@hotmail.com.

Thank you in advance.

Regards,
Mubarak


Acknowledge(0)
Amend(0)

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, 1694 views)

Acknowledge(0)
Amend(0)

Thank you, Mubarek. I will definitely 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
Acknowledge(0)
Amend(0)

Dear All,

Please use the Excel sheet posted by me. It will convert up to 999,999,999 digits. For example:

=spellnumber(999999999.25)

Rupees Ninety Nine Crores Ninety Nine Lakhs Ninety Nine Thousand Nine Hundred Ninety Nine and Paise Twenty Five Only

Thank you.

From India, Bangalore
Acknowledge(0)
Amend(0)

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, 989 views)

Acknowledge(1)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.