3. After inserting the code, save and close the code window, go back to the worksheet, and enter this formula: =RupeeFormat(A2) into a blank cell, and then drag the fill handle down to apply this formula to other cells, all the numbers have been spelled out in rupees, see screenshot...
Tip.If you've got a column with numbers, you can simply drag down the formula to get them all spelled. Note.The formula will be custom user-defined, and if the workbook is opened on another machine without Ultimate Suite for Excel installed, the result may be lost. The function arguments...
Read More:How to Convert Number to Words in Excel Step 4 – Apply VBA Code Copy the following VBA code: Public Function SpellTaka(SpNum As String) Dim yDP As Integer Dim yArr As Variant Dim yR_Paisa As String Dim yNum As String Dim yF As Integer Dim yTemp As String Dim yStr As ...