Formats a number and converts it to text.

What is text function in excel. Value-A numeric value that you want to be converted into text. It is optional argument. The syntax of the function is.

Converts a number plus the suffix Baht into Thai text. It can be used as a worksheet function WS in Excel. ISTEXT will return TRUE when value is text.

TEXTvalue format_text Where the value is the number or reference to the cell containing the number you want to format and format_text is the format you want enclosed in double quotes. What is the TEXT Function in Excel. In the first argument you have to input the date value or the cell reference of a date.

Its useful in situations where you want to display numbers in a more readable format or you want to combine numbers with text or symbols. The TEXT function lets you change the way a number appears by applying formatting to it with format codes. TEXT value format_text Where the function arguments are.

Consequently you wont be able to use the result of your Text formula in other calculations. Often value is supplied as a cell address. The format definitions that can be.

If theres such a need you can keep the original values hidden or kept out of sight and use them in other formulas. Then you can define a proper date format by your own customization. As a worksheet function the T function can be entered as part of a formula in a cell of a worksheet.