Information abt EXCEL formula
Querist : Anonymous
I need a formula in EXCEL which converts the Value of Figures into Words Automatically.
Ex : If I enter 25,000/- in should convert into Words Twenty Five Thousand only.
Pls if anybody knows abt it Pls help me!!!!!!
To convert number into words : Follow below steps
1. Press Alt+F11
2. Click insert on menu bar > Module Insert
3. Copy & paste in module the following code
Function words(fig, Optional point = "Point") As String
Dim digit(14) As Integer
alpha = Array("", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine", "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")
figi = Trim(StrReverse(Str(Int(Abs(fig)))))
For i = 1 To Len(figi)
digit(i) = Mid(figi, i, 1)
Next
For i = 2 To Len(figi) Step 3
If digit(i) = 1 Then
digit(i) = digit(i - 1) + 10: digit(i - 1) = 0
Else: If digit(i) > 1 Then digit(i) = digit(i) + 18
End If
Next
For i = 1 To Len(figi)
If (i Mod 3) = 0 And digit(i) > 0 Then words = "hundred " & words
If (i Mod 3) = 1 And digit(i) + digit(i + 1) + digit(i + 2) > 0 Then _
words = Choose(i / 3, "thousand ", "million ", "billion ") & words
words = Trim(alpha(digit(i)) & " " & words)
Next
If fig Int(fig) Then
figc = StrReverse(figi)
If figc = 0 Then figc = ""
figd = Trim(WorksheetFunction.Substitute(Str(Abs(fig)), figc & ".", ""))
words = Trim(words & " " & point)
For i = 1 To Len(figd)
If Val(Mid(figd, i, 1)) > 0 Then
words = words & " " & alpha(Mid(figd, i, 1))
Else: words = words & " Zero"
End If
Next
End If
4.If fig function > user defined > A1 or (relevent cell)
Or after completing step 1 to 4 use formula = words(A1)
5.Then if in CELL A1 is 10 number the result is ten.
Regards
CS Sunita Jamkhande
Querist : Anonymous
Querist : Anonymous
Querist : Anonymous
Click here to login now
Similar Resolved Queries
- Clarification on GST, TDS, and Accounting Provisions for Import/Export
- Clarification on GST, TDS, and Accounting Provisions for Import/Export Commission Agents,profes. ser
- Reward for festival
- TDS Return Statement Status
- Capital gain on commercial property and investment in residential property
- RCM and same line
- Appointment of Auditor By Form ADT-1
- Rent agreement of House of deceased person
- Closer of business and itc of capital goods
- Import of Capital Machine
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
- ITC not to be taken in accounts & GSTR-3B
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
