The first number is converted to words in rupees. Use theFill Handletool and drag it down from cellC5toC12. Download the Practice Workbook Related Articles How to Spell Number Without Currency in Excel How to Spell Number in Taka in Excel How to Spell Number in Dirhams in Excel [Solved] ...
Function NumberToWords(ByVal Number As Long) As String Dim Ones() As String Dim Tens() As String Dim Group() As String Dim Result As String Ones = Split("One,Two,Three,Four,Five,Six,Seven,Eight,Nine", ",") Tens = Split("Ten,Eleven,Twelve,Thirteen,Fourteen,Fifteen,Sixteen,Seventeen,E...
We used anIf statementto check if the value returned by theValfunction and the associated functions in it is equal to1or not. If it is1, then it returns the defined cases as output. Terminate the process. If Val(Left(tens_text, 1)) = 1 Then Select Case Val(tens_text) Case 10: ...