Function Reference: VALUETOTEXT
Number Formatting - Format Codes
| Syntax |
| =VALUETOTEXT(value,[format]) |
| Purpose / Description |
| Returns a text string representing a value formatted as a string. May employ concise or strict formatting rules. |
| Arguments |
| Name |
Type |
Description |
| value |
any |
A constant, reference or nested expression that provides the value that is to be represented as a text string. |
| [format] |
logical |
An optional constant, reference or nested expression that provides a logical flag that indicates if strict formatting is to apply. Defaults to FALSE if omitted.
| |
Concise |
the values appears as a simple text string representation. |
| 1 |
Strict |
text strings are included in quotation marks |
|
| Return Values |
| Type |
Specific Value |
Description |
| text string |
|
The value, including any errors is presented as a text string representation of the value. |
| Notes / Comments / Advice / Warnings |
| Comment: |
This function is useful in some more abstract and advanced calculations, where it is useful to convert all values to arrays of strings.. It can also be useful to convert the visible contents of cells that have been changed to data types to text for summarising. |
| Examples: |
Open / download sample workbook: VALUETOTEXT.xlsx |
| |