Function Reference: TEXT
Number Formatting - Format Codes
| Syntax | ||
| =TEXT(value,format_text) | ||
| Purpose / Description | ||
| Returns a text string representing a value formatted according to the custom number formatting string. | ||
| Arguments | ||
| Name | Type | Description |
| value | number | A constant, reference or nested expression that provides the number whose value is to be represented a formatted number in a text string. |
| format_text | text string | A constant, reference or nested expression that provides a custom number formatting string that determines how the value is represented. The format may not be "General" and any spacing (*) characters in the string will be ignored. It may contain a text formatting zone. |
| Return Values | ||
| Type | Specific Value | Description |
| text string | If the value passed to the number argument is a number or a value that can be coerced to number, the result is the formatted text string containing the result formatted as per the format_text formatting code. If the value is a text string that cannot be coerced to number value, it is returned unmodified. |
|
| error | Any errors referenced by arguments are returned due to propagation of error values. | |
| Notes / Comments / Advice / Warnings | ||
| Note: | For details on formatting codes, see the Ready Reference article: Number Formatting - Format Codes | |
| Comment: | The knowledge you gain in our courses, using custom number formatting can be utilised in deploying TEXT functions to create formatted strings for charts, diagrams and titling.. | |
| Examples: | Open / download sample workbook: TEXT.xlsx | |