Currency Number To A Text Format - Xls Download

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

Dear All,

Please find the Excel sheet. After enabling the macro, there is a function called Spellnumber that will convert numbers to words.

For example:
```
=spellnumber(123)
```
Result: Rupees One Hundred Twenty Three Only

Thank you.

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

Hi,

Please find the attached Excel Sheet. It will convert the currency to number format up to 99,999 in a normal Excel sheet without Macros. I have written the formula. Suggestions/advice are welcome.

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.

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.

Here is the corrected text with proper paragraph formatting:

User input:
Here is the attachment. Please see. There may be some mistakes.