VALUE
|
Form
|
Where
|
Result
|
|---|---|---|
|
VALUE(x)
|
x is text
|
A number
|
Description
Converts text to a number, so long as the text contains only digits.
|
Example
|
Result
|
|---|---|
|
=VALUE("415") * 2
|
830
|
T
|
Form
|
Where
|
Result
|
|---|---|---|
|
T(n)
|
n is a number
|
Text
|
Description
Converts a number into text.
|
Example
|
Result
|
|---|---|
|
=LEN(T(415))
|
3
|