[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
VALUE ( string )
Description: Converts string to a number.
Arguments:
|
Name |
Type |
Description |
|
string |
Designates a string that contains a number formatted using any number, currency, date, or time format. (See §3.8.31 for the set of formats.) Date and time strings are converted to their equivalent serial value. |
Return Type and Value: number – The number represented by string.
[Example:
VALUE("123.456") results in 123.456
VALUE("$1,000") results in 1000
VALUE("23-Mar-2002") results in the corresponding serial value
VALUE("16:48:00")-VALUE("12:17:12") results in 0.188056
end example]