Be the first user to complete this post
|
Add to List |
VBA-Excel: Convert Numbers (Rupees) into Words OR Text - Updated Till 1000000 Crore With Decimal Numbers
To Convert Numbers into Text, please follow the steps below
Download Link: NumberToWords
Example:
1000000000.00 | Rupees One Hundred Crores |
345.56 | Rupees Three Hundred Fourty Five and Fifty Six paise only |
12312312.00 | Rupees One Crore Twenty Three Lacs Twelve Thousand Three Hundred Twelve |
999999999.00 | Rupees Ninty Nine Crores Ninty Nine Lacs Ninty Nine Thousand Nine Hundred Ninty Nine |
9999999999.00 | Rupees Nine Hundred Ninty Nine Crores Ninty Nine Lacs Ninty Nine Thousand Nine Hundred Ninty Nine |
1212.34 | Rupees One Thousand Two Hundred Twelve and Thirty Four paise only |
23231111.00 | Rupees Two Crore Thirty Two Lacs Thirty One Thousand One Hundred Eleven |
Steps:
- Open a new WorkBook
- Create a Button
- Copy Paste the Complete Code
- Assign the macro to the button created
- Write the Number in Column A
- Click the Convert button
- You will find the text of number in column B
Complete Code:
Download Link : NumberToWords
Also Read:
- VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations
- VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
- Excel-VBA : Open a Excel File using Another Excel File using Browse Option.
- VBA-Excel: Open an Existing Word Document