VALUE
Description
Converts the specified text into a numeric value. The value to convert must be in a
recognized date, time, or number format.
Syntax
VALUE(
text
)
- text: The text to convert.
Example
Formula | Result |
|---|---|
=VALUE(A1)
Where cell A1 contains
$2,451.00
.
| 2451 |
=VALUE(A1)
Where cell A1 contains
Regional Sales Manager
.
| #VALUE |