| Syntax |
| =VALUE(text) |
| Purpose / Description |
| Returns the number value of text string that contains a formatted number, currency amount, percentage, or date and/or time. |
| Arguments |
| Name |
Type |
Description |
| text |
text string |
A constant, reference or nested expression providing the text string from which the number value is to be derived. |
| Return Values |
| Type |
Specific Value |
Description |
| number |
|
The number represented by the text string, but only if the text argument is a blank or a text string that can be converted. |
| error |
#VALUE! |
If the text argument is a logical value or a text string that cannot be converted to a number, as it contains characters other than digits (0-9), negatives (- or parentheses), currency symbol, date and time separators, grouping symbol. The characters are dependent upon the user's regional settings. |
| error |
|
Any errors referenced by arguments are returned due to propagation of error values. |
| Notes / Comments / Advice / Warnings |
| Note: |
note here |
| Comment: |
For dates and times, DATEVALUE or TIMEVALUE return the numeric equivalent of the date part and time part of a string respectively. |
| Advice: |
on the fly coercion of type can also be achieved with 1*text, or some modellers use --text |
| Examples: |
Open / download sample workbook: VALUE.xlsx |
| |