Manuals/calci/VALUE

Revision as of 20:46, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''VALUE'''</font></font></font><font color="#484...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

VALUE(txt)

where txt   is the text enclosed in quotation marks that want to convert.


It converts a text string that represents a number to a number.


VALUE


Let’s see an example in (Column1 Row 1)

I.e.=VALUE(C1R1)

=VALUE(“$4760”) is 4760


Syntax

Examples

Description

Column1 Column2 Column3 Column4
Row1 4760 4760
Row2
Row3
Row4
Row5
Row6