Difference between revisions of "Documentation/How Tos/Calc: VALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
m (→Example:) |
||
(8 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: TEXT function|TEXT]] | ||
* [[Documentation/How_Tos/Calc: T function|T]] | * [[Documentation/How_Tos/Calc: T function|T]] | ||
Line 38: | Line 43: | ||
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Text functions]] |