Data Conversion Functions
The following section details a number of functions that can be used to convert text strings to numbers and vica-versa.
VALUE
Converts text to a number, so long as the text contains only digits.
| Syntax | Where | Result |
|---|---|---|
| VALUE(x) | x is text | A number |
| Example | Result |
|---|---|
| =VALUE("415") * 2 | 830 |
T
Converts a number into text.
| Syntax | Where | Result |
|---|---|---|
| T(n) | n is a number | Text |
| Example | Result |
|---|---|
| =T(415) | "415" |