FUNCTION CATALOGUE / TEXT
VALUE Excel function
Converts numeric text to a number.
Correct sentence to use
Convert [text] to a number.
Modify this query in PlainFormula →Example formula
=VALUE(A2)
Converts recognised numeric text.
Syntax
VALUE(text)
Argument signature: text
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.