The VALUE function converts a text string that represents a number into a numeric value. This function is commonly used to convert extracted or formatted text into numbers for calculations.
Syntax
VALUE(value)
Arguments
value: The text string that contains a number.
Return value
Returns the numeric value represented by the text string.
Example
VALUE(MID(ProductCode,9,6))
In this example, the VALUE function converts the extracted portion of the Product Code field into a numeric value. For example, Product0101001 returns 101001.
