Difference between revisions of "Documentation/How Tos/Calc: TEXT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||
Line 16: | Line 16: | ||
: returns the text <tt>'''12.35'''</tt>, if in your locale <tt>'''###.##'''</tt> is a format code meaning "up to three integer digits and at most two decimal digits". | : returns the text <tt>'''12.35'''</tt>, if in your locale <tt>'''###.##'''</tt> is a format code meaning "up to three integer digits and at most two decimal digits". | ||
− | + | {{Documentation/SeeAlso| | |
− | + | * [[Documentation/How_Tos/Calc: T function|T]] | |
− | + | * [[Documentation/How_Tos/Calc: VALUE function|VALUE]] | |
− | + | * [[Documentation/How_Tos/Calc: N function|N]]''' | |
− | + | * [[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:22, 25 February 2009
TEXT
Converts a number into text according to a given format.
Syntax:
TEXT(number; format)
- returns number converted to text, according to the format code specified by format.
- Example format codes are found in the Format - Cells... dialogue, in the box labelled Format Code. These depend on your locale.
- This function should therefore not be regarded as portable.
Example:
TEXT(12.34567;"###.##")
- returns the text 12.35, if in your locale ###.## is a format code meaning "up to three integer digits and at most two decimal digits".