Be the first user to complete this post

  • 0
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

1000000000.00Rupees One Hundred Crores
345.56Rupees Three Hundred Fourty Five and Fifty Six paise only
12312312.00Rupees One Crore Twenty Three Lacs Twelve Thousand Three Hundred Twelve
999999999.00Rupees Ninty Nine Crores Ninty Nine Lacs Ninty Nine Thousand Nine Hundred Ninty Nine
9999999999.00Rupees Nine Hundred Ninty Nine Crores Ninty Nine Lacs Ninty Nine Thousand Nine Hundred Ninty Nine
1212.34Rupees One Thousand Two Hundred Twelve and Thirty Four paise only
23231111.00Rupees Two Crore Thirty Two Lacs Thirty One Thousand One Hundred Eleven


  • 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

Convert Number to Words
Convert Number to Words

Also Read:

  1. VBA-Excel — AttachmentFetcher — Download all the Attachments from All the Mails of Specific Subject in Microsoft Outlook .
  2. VBA-Excel: Select and Activate Cells - Select
  3. VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
  4. VBA-Excel: Working with Bookmarks- Insert text before Bookmark
  5. VBA-Excel: Open an Existing Word Document
  6. VBA-Excel: Add/Insert multiple objects from a folder in an Excel Document.
  7. VBA-Excel: Create worksheets with Names in Specific Format/Pattern.
  8. VBA-Excel: Format already written text in a word document – Format Paragraphs