VALUE Function Explained

The VALUE function in Microsoft Excel converts a text string that represents a number to a number. It is useful for when a number is stored as text, and you need to use it in a calculation. The syntax for the VALUE function is VALUE(text), where text is the text string that you want to convert.

VALUE Function Syntax

VALUE(text)

  • text: A string that represents a number.