In many instances you are required to format number with Text at the beginning. Value is the numerical value that we need to convert to text. Other values and formulas dont require quotation marks.
For example range K2L5 shows that 02854 can be displayed with a percent symbol.
Lets look as the following data set example. Save and close this code and go back the worksheet in a blank cell enter this formula NumberstoWords A2 A2 is the cell you want to convert the number to an English word see screenshot. In many instances you are required to format number with Text at the beginning. While Excel cannot count the number of words it can count the number of spaces in a sentence.