Manuals/calci/VALUE

VALUE (Text)

where,

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Text} is a text that represents a number.
- VALUE() converts a text string representing a number, to a number string.

Description

VALUE(txt)

e.g. VALUE("$1760") returns 1760 as a result.

VALUE function is used to convert a text containing numbers to a number string.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Text} is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command.
Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Text} can be a number, date or time values in proper formats.
If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Text} is invalid, Calci displays #N/A error message.

Consider the following examples that demonstrate the use of VALUE function:

=VALUE(A1) : Displays 1000 as the output.
=VALUE(B1) : Converts date to its serial number. Displays 40392.71486111111 as the output.