writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − − + − + − Line 13:
Line 11: − + − + − +
no edit summary
=VALUE(txt)=
<div style="font-size:30px">'''VALUE (Text)'''</div><br/>
where,
where,
*<math>txt</math> is a text that represents a number.
*<math>Text</math> is a text that represents a number.
**VALUE() converts a text string representing a number, to a number string.
VALUE() converts a text string representing a number, to a number string.
== Description ==
== Description ==
*VALUE function is used to convert a text containing numbers to a number string.
*VALUE function is used to convert a text containing numbers to a number string.
*<math>txt</math> is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command.
*<math>Text</math> is a text value and should be enclosed in double quotes (e.g. "$100"), when directly entered in the command.
*<math>txt</math> can be a number, date or time values in proper formats.
*<math>Text</math> can be a number, date or time values in proper formats.
*If <math>txt</math> is invalid, Calci displays #N/A error message.
*If <math>Text</math> is invalid, Calci displays #N/A error message.
== Examples ==
== Examples ==