Meaning Of Excel Text
The format definitions that can be used in the excel text function are shown in the table below.
Meaning of excel text. If you ve already entered data and excel has removed your leading 0 s you can use the text function to add them back. The excel text function is used to convert numbers to text within a spreadsheet. As the name suggest the task of text function is to convert a numeric value to a string.
This function comes quite handy when you want to display numbers in a more readable format or in such a format that makes more sense. Text is available in all versions of excel. Excel text function falls under the category of string formulas.
Essentially the function will convert a numeric value into a text string.