Difference between revisions of "Documentation/How Tos/Calc: VALUE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m (→Syntax:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
| Line 27: | Line 27: | ||
: returns the datetime serial number for 3rd April 2009. | : returns the datetime serial number for 3rd April 2009. | ||
| − | + | {{Documentation/SeeAlso| | |
| − | + | * [[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]]}} |
Revision as of 14:25, 25 February 2009
VALUE
Returns a number, given a text representation.
Syntax:
VALUE(text)
- converts text to a number. text may represent: a number, including fractions, exponential notation and (locale dependent) decimal point and thousands separator; a percentage; or a date or time (the datetime serial number is returned).
Example:
VALUE("12")
- returns 12 as a number.
VALUE("1,234.56")
- returns 1234.56 if your locale recognises the thousands separator ',' and decimal point '.'.
VALUE("1 1/2")
- returns 1.5 (fraction).
VALUE("1E3")
- returns 1000 (exponential notation).
VALUE("50%")
- returns 0.5 (percentage).
VALUE("2009-04-03")
- returns the datetime serial number for 3rd April 2009.
