FIXED in Collabora Office: Control Decimal Text and Thousands Separators

• Introduced: the original Collabora release and launch date are not established by the reviewed sources.
• Availability: documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployment support is not inferred from the desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent controls; no native Collabora execution.

=FIXED(Number; [Decimals = 2 [; NoThousandsSeparators = FALSE]])

Decimals defaults to two. Negative Decimals rounds to the left of the decimal point. A fractional Decimals argument is truncated, rather than rounded to its nearest integer.

NoThousandsSeparators defaults to FALSE. TRUE or a nonzero value suppresses grouping; zero or an omitted argument retains the current locale’s thousands separator. The official reference explicitly demonstrates an omitted middle argument, as in =FIXED(123456.789;;TRUE).

These examples use English (USA) separators: a full stop for decimals and a comma for grouping. The numeric value and the returned text are different data types, so retain the original number for totals.

Enter only the numeric column in A2:A5. In B2 use =FIXED(A2;2); in C2 use =FIXED(A2;2;TRUE). Fill both down.

The optional flag changes grouping, not decimal precision. For the first row, =FIXED(A2;;TRUE) uses the default two decimals and gives the same ungrouped output as C2.

A grouping comma is part of the returned string. It should not be mistaken for a delimiter separating two values in an exported file. Decide the required field format before assembling a text export.

With 12345.625 in E2, compare:

The last two use precision 1 and 0 after truncation. This is not a claim that the Number itself is truncated: Number is rounded to the resulting precision.

For grouping, =FIXED(E2;-2;FALSE) is 12,300. For a nonzero flag, =FIXED(E2;2;2) is 12345.63, following the explicit nonzero rule.

Enter numeric measurements 2.5, 12 and 0.125 in G2:G4. In H2 enter =FIXED(G2;3;TRUE) and fill down. Expected strings are 2.500, 12.000 and 0.125.

These fields all use three digits after the decimal point, but they do not have identical overall lengths: their integer parts differ. FIXED is not a general left-padding function for a fixed-width file.

To check the quantities under an explicit parsing contract, use =NUMBERVALUE(H2;".") in I2 and fill down. Expected numbers are 2.5, 12 and 0.125. NUMBERVALUE makes the decimal separator explicit rather than relying on another locale’s automatic parser.

For two inputs of 0.125, formatting each with two decimals produces 0.13 twice. The unrounded numeric total is 0.25, so =FIXED(0.125+0.125;2;TRUE) gives 0.25.

Summing separately rounded numeric lines gives 0.26 instead. Choose and document the rounding policy; do not reconstruct totals from display strings accidentally. ROUND is appropriate when the calculation itself needs a rounded number.

The source establishes the documented precision and grouping rules, but does not provide every invalid-input error or exact native floating-point boundary. Positive finite examples and independent decimal models are used here. DOLLAR adds currency formatting under its separate locale rules.

• Collabora Office 26.04: FIXED.
• Editorial testing standards.

Complete dedicated product documentation reviewed. Outputs are independent decimal, positional, character or type models, or explicit vendor controls; no native Collabora execution. Formulas use English names and semicolon separators. Optional-argument brackets describe syntax and are not typed into working formulas.