VALUE
The VALUE function returns a number value, even if the argument is formatted as text.
VALUE(source-string)
source-string: A number, currency, percentage, fraction, numeral system, scientific value, or text containing any of these types of values. source-string is enclosed in quotes. source-string can also be a reference to a cell formatted as a star rating, slider, stepper, or pop-up menu.
Notes
If the argument can’t be converted to a number value (it doesn’t contain a number), the function returns an error.
Examples |
---|
=VALUE("$100.50") returns the number 100.5. =VALUE("22") returns the number 22. =VALUE("75%") returns the number 0.75. =VALUE("1 3/4") returns the number 1.75. =VALUE("3E 08") returns the number 300,000,000. =VALUE(RIGHT("The year 1953", 2)) returns the number 53. |