Documentation/Calc Functions/TEXT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

TEXT

Category:

Text

Summary:

Converts a number into text according to a given format.

Syntax:

TEXT(Number; Format)

Returns:

Arguments:

Number is the numerical value to be converted.

Format is the text which defines the format. Use decimal and thousands separators according to the language set in the cell format.

Additional details:

See also https://help.libreoffice.org/6.4/en-US/text/shared/01/05020301.html?&DbPAR=CALC&System=WIN: custom format codes defined by the user.

Examples:

=TEXT(12.34567;"###.##") returns the text 12.35

=TEXT(12.34567;"000.00") returns the text 012.35

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: