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
Example:

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

 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

Convert Number to Words
Convert Number to Words



Also Read:

  1. VBA-Excel: Add Worksheets For All The Given Dates Except Weekends and Copy The Common Template In Each Worksheet
  2. VBA-Excel: Format the Existing Table in a Word document
  3. Introduction to Excel WorkBook
  4. Send Mail With Multiple Different Attachments From MS Outlook using Excel.
  5. VBA-Excel: Format already written text in a word document – Format Paragraphs
  6. Excel-VBA : Open a Excel File using Another Excel File using Browse Option.
  7. Excel-VBA : Prevent Adding New Worksheet
  8. VBA-Excel: Read XML by Looping through Nodes