technicalsamani

How to Convert Number into Word in Excel in Indian Rupees Convert number into word in excel in Indian Rupees,, this code will work in all version of Microsoft Excel like (2003, 2007, 2010, 2013,2016). Just fallow these easy steps. 1)         Copy this cod Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As String Dim tens(9) As String WORDs(1) = "One" WORDs(2) = "Two" WORDs(3) = "Three" WORDs(4) = "Four" WORDs(5) = "Five" WORDs(6) = "Six" WORDs(7) = "Seven" WORDs(8) = "Eight" WORDs(9) = "Nine" WORDs(10) = "Ten" WORDs(11) = "Eleven" WORDs(12) = "Twelve" WORDs(13) = "Thirteen" WORDs(14) = "Fourteen" WORDs(15) = "Fifteen" WORDs(16) = "Sixteen" WORDs(17) = "Seventeen" WORDs(18) = "Eighteen" WORDs(19) = "Nineteen" tens(2) = "T...

Excel functions for changing text case  Microsoft Excel has three special functions that you can use to change the case of text. They are  UPPER ,  LOWER  and  PROPER . The  upper()  function allows you to convert all lowercase letters in a text string to uppercase. The  lower()  function helps to exclude capital letters from text. The  proper()  function makes the first letter of each word capitalized and leaves the other letters lowercase (Proper Case). All three of these options work on the same principle, so I'll show you how to use one of them. Let's take the  Excel uppercase function  as an example. Enter an Excel formula Insert a new (helper) column next to the one that contains the text you want to convert. Note:  This step is optional. If your table is not large, you can just use any adjacent blank column. Enter the equal sign   (=)  and function name   (UPPER)  in the adjacent cell of the...