What is VALUE?
Converts a text string that represents a number to a number. Essential for fixing 'numbers stored as text'.
Syntax
=VALUE(text)
Example
Formula: =VALUE(\
Result: 123.45
How It Works
Converts text '123.45' to numeric 123.45. Also converts date/time text to serial numbers. Returns #VALUE! for non-numeric text.