TEXT |
| TEXT(value, format_text) |
Returns the number as a formatted text string. |
| value | The value representing the number you want converted to text. |
| format_text | The format to display the result: "d" = day as a number, no leading zero "dd" = day as a number with a leading zero "ddd" = day as an abbreviation (3 characters) "dddd" = day in full "m" = month as a number, no leading zero "mm" = month as a number with a leading zero "mmm" = month as an abbreviation (3 characters) "mmmm" = month in full "yy" = year as a two digit number "yyyy" = year as a four digit number "h" = hour as a number, no leading zero "hh" = hour as a number with a leading zero "m" = minute as a number, no leading zero "mm" = minute as a number with a leading zero "s" = second as a number, no leading zero "ss" = second as a number with a leading zero |
| REMARKS |
| * If "format_text" is not enclosed in speech marks, then #NAME? is returned. * The "value" can be a numeric value, a cell reference or a formula that evaluates to a numeric value. * The "format_text" argument must be enclosed in speech marks. * The "format_text" cannot contain an asterisk (*). * The "format_text" can include any valid Time Format or Custom Format. * Formatting a cell using the (Format > Cells) dialog box only changes how the value is displayed. * Using this function will actually change the value to text, and the actual value might have changed. * This function can be used with other languages (for example Japanese). * You can use the DOLLAR function to return a text string of a number with the currency formatting $0,000.00. * You can use the FIXED function to return the text string of a number rounded to a fixed number of decimal places. * You can use the ISTEXT function to return the boolean True or False depending if the value is text. * You can use the TEXTAFTER function to return the characters from the end of a text string after a delimiter. * You can use the TEXTBEFORE function to return the characters from the start of a text string before a delimiter. * You can use the TEXTJOIN function to return the text string that is a concatenation of several strings with a delimiter. * You can use the TEXTSPLIT function to return a text string split into multiple columns using delimiters. * You can use the VALUETOTEXT function to convert any value into text. * The equivalent VBA function is VBA.FORMAT * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top