Converts the specified text that represents a number to a number.
Syntax
 Copy Code
|
|---|
VALUE( Text text ) → Number |
Parameters
- text
- Required. The text to convert.
Remarks
The text argument can be in any number, date, or time formats recognized by <variable not found>. If text is not in one of these formats, VALUE returns the #VALUE! error value. If text is an empty text, the return value is 0.
Example
| Formula
Copy Code
|
|---|
=VALUE("$1,000") |