In Excel, the Value function converts a text value that represents a number to a number.
The syntax for the Value function is:
Value( text )
text is the text value to convert to a number.
If text is not a number, the Value function will return #VALUE!.
