I have named this function NUM_TO_IND_RUPEE_WORD. Now I am moving to another of changing the text to numbers. The syntax of this function is.
Use the SpellNumber function in individual cells Type the formula SpellNumber A1 into the cell where you want to display a written number where A1 is the cell containing the number you want to convert.
I had never imagined that we could convert numbers into words. You can force a recalculation by pressing the F9 key on the keyboard or pressing Formulas tab - Calculation group - Calculate Now. To use this function select the cell where you want the converted number to go and type. Click the Save button disk icon and then go back to your spreadsheet window.