Documentation/Calc Functions/VALUE
Jump to navigation
Jump to search
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
VALUE
Category:
Text
Summary:
Converts a text string into a number.
Syntax:
VALUE("Text")
Returns:
Arguments:
Text is the text to be converted to a number.
Additional details:
Examples:
=VALUE("4321") returns 4321
=VALUE("abc") returns Err:502 (Invalid argument)
=VALUE(A1) returns Err:502 (Invalid argument) where A1 contains abc
=VALUE("abc123") returns Err:502 (Invalid argument)
=VALUE(A1) returns 4321 where A1 has the text format and contains 4321
=VALUE(A1) returns 4321 where A1 contains '4321
=VALUE(A1) returns 0 where A1 is an empty cell
=VALUE(4321) returns 4321