Syntax: VALUE(S)
S = a string value
VALUE returns the numeric value represented by string S, or 0 if S does not represent a number.
Examples:
VALUE(``324.399'') = 324.399
VALUE(G10) = 1.7, where G10 = ``1.7''
VALUE(M8) = 0, where M8 = ``cosine''
Excel function: VALUE