VALUE

Syntax:

VALUE ( string )

Description: Converts string to a number.

Arguments:

Name

Type

Description

string

text

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: