Functions
VALUE
Convert text to number
Try it
When to use it
When should I use VALUE?
Use VALUE to convert a number stored as text into a real number so it can be used in calculations.
What happens if VALUE gets text that is not a number?
VALUE returns a #VALUE! error when the text cannot be interpreted as a number, so clean or validate the input first if it may contain letters.
Use cases
Turn an imported numeric string into a number
Coerce a text digit so it can be summed
Used in
Syntax
VALUE(text)Examples
=VALUE("123") // => 123
=VALUE("7/20/1969") // => 25404
=VALUE("12:00:00") // => 0.5