VALUE

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(Product Code, 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.

Excel equivalent

VALUE