Documentation/Calc Functions/FIXED
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
FIXED
Category:
Text
Summary:
Returns a number as text with a specified number of decimal places and optional thousands separators.
Syntax:
FIXED(Number; Decimals; NoThousandsSeparators)
Returns:
Arguments:
Number refers to the number to be formatted.
Decimals refers to the number of decimal places to be displayed.
NoThousandsSeparators (optional) determines whether the thousands separator is used. If the parameter is a number not equal to 0, the thousands separator is suppressed. If the parameter is equal to 0 or if it is missing altogether, the thousands separators of your current locale setting are displayed.
Additional details:
Examples:
=FIXED(1234567.89;3) returns 1,234,567.890 as a text string.
=FIXED(1234567.89;3;1) returns 1234567.890 as a text string.
Related LibreOffice functions:
ODF standard:
OpenDocument 1.2 OpenDocument 1.3