# 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
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).**text**

### Example:

**VALUE("12")**

- returns
as a number.**12**

**VALUE("1,234.56")**

- returns
if your locale recognises the thousands separator ',' and decimal point '.'.**1234.56**

**VALUE("1 1/2")**

- returns
(fraction).**1.5**

**VALUE("1E3")**

- returns
(exponential notation).**1000**

**VALUE("50%")**

- returns
(percentage).**0.5**

**VALUE("2009-04-03")**

- returns the datetime serial number for 3rd April 2009.