Converts a text string that represents a number into a number.
Syntaxis
VALUE(text)Argumenten
textvereist
The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.
The VALUE function is primarily used to convert text formatted numbers into numeric values that Excel can perform calculations on. It is useful when importing data from external sources where numbers are stored as text strings.
=VALUE("1,000")→1000Converts the text string '1,000' into the numeric value 1000.
Select the target cell
Click on the cell where you want the numeric result to appear.
Enter the formula
Type =VALUE( followed by the cell reference containing the text and a closing parenthesis.
This error occurs if the text string cannot be recognized as a valid number format.