Difference between revisions of "Documentation/How Tos/Calc: VALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Syntax:) |
m (→Example:) |
||
(10 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE:VALUE function}} |
+ | {{Documentation/CalcFunc TextTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_UPPER_function | ||
+ | |NextPage=none | ||
+ | }}__NOTOC__ | ||
== VALUE == | == VALUE == | ||
Line 13: | Line 18: | ||
<tt>'''VALUE("1,234.56")'''</tt> | <tt>'''VALUE("1,234.56")'''</tt> | ||
− | : returns <tt>'''1234.56'''</tt> if your locale | + | : returns <tt>'''1234.56'''</tt> if your locale recognizes the thousands-separator ',' and decimal point '.'. |
<tt>'''VALUE("1 1/2")'''</tt> | <tt>'''VALUE("1 1/2")'''</tt> | ||
Line 24: | Line 29: | ||
: returns <tt>'''0.5'''</tt> (percentage). | : returns <tt>'''0.5'''</tt> (percentage). | ||
− | <tt>'''VALUE(" | + | <tt>'''VALUE("2019-04-03")'''</tt> |
− | : returns the datetime serial number for 3rd April | + | : returns the datetime serial number for 3rd April 2019. |
− | + | {{SeeAlso|EN| | |
− | + | * [[Documentation/How_Tos/Calc: TEXT function|TEXT]] | |
− | + | * [[Documentation/How_Tos/Calc: T function|T]] | |
− | + | * [[Documentation/How_Tos/Calc: N function|N]] | |
− | + | * [[Documentation/How_Tos/Calc: DATEVALUE function|DATEVALUE]] | |
− | + | * [[Documentation/How_Tos/Calc: TIMEVALUE function|TIMEVALUE]] | |
− | + | * [[Documentation/How_Tos/Calc: Text functions|Text functions]] | |
− | [[Documentation/How_Tos/Calc: Functions listed alphabetically| | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
− | [[Documentation/How_Tos/Calc: Functions listed by category| | + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |
+ | [[Category: Documentation/Reference/Calc/Text functions]] |