FIXED in Google Sheets: Decimal Places and Separator Control

• Introduced: first introduction date is not established by the reviewed official history; no desktop release number is inferred.
• Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
• Checked: October 14, 2026; official FIXED reference. Documentation and independent models, with no native Sheets execution or wider client certification.

=FIXED(number,[number_of_places],[suppress_separator])

The dedicated reference makes number_of_places optional without stating its numeric default. All worked formulas therefore supply that count explicitly. Its description is about decimal places even though one explanatory sentence loosely says significant digits; the examples below interpret the count as places after the decimal separator.

Google says excess fractional digits are rounded, not truncated, and missing places are padded with zeros. The examples use a U.S.-locale display model, ordinary positive or negative numbers and nonnegative integer precision. Negative counts, exact midpoints and native length/error limits remain unverified here.

Enter 7654.328 in A2. Evaluate these formulas separately:

The first two agree because grouping is enabled when the third argument is omitted. The fourth decimal zero in the final result is padding, not an extra measured digit.

At two places, 7654.328 rounds to 7654.33. Truncating to 7654.32 would follow a different rule from the one Google describes.

Enter 3.5, 1500, 0.068 and −2.347 in D2:D5. In E2 enter and fill down:

=FIXED(D2,2,1)

Expected representations are 3.50, 1500.00, 0.07 and -2.35. In F2 use ="Quantity: "&E2 and fill down. The first label is Quantity: 3.50; the last is Quantity: -2.35.

This is a presentation workflow. Retain D as the numeric source for calculations instead of treating a formatted report label as the original quantity. Suppressing a thousands separator does not by itself establish that an output is suitable for every numeric import convention.

The four original D values sum to 1501.221. Formatting the numeric total with:

=FIXED(SUM(D2:D5),2,1)

gives the expected representation 1501.22. By comparison, the displayed row magnitudes 3.50 + 1500.00 + 0.07 − 2.35 also happen to total 1501.22 for this fixture. Agreement in one dataset does not prove that row rounding and total rounding are interchangeable.

For a counterexample, place 2.004 in H2:H4. Formatting each value to two places displays 2.00 three times. The raw sum is 6.012, and =FIXED(SUM(H2:H4),2,1) displays 6.01.

A numeric row-rounding helper, =ROUND(H2,2), filled down before summing, instead gives total 6.00. Select the operation order deliberately and keep it consistent across the report.

Google’s short FIXED body describes presentation and rounding but does not explicitly identify its return type. This documentation-only audit does not use the function’s Text catalogue category as proof of a complete type/coercion rule.

Before depending on a native return type in a production workflow, inspect an isolated result with ISTEXT and ISNUMBER. Those specific FIXED type outcomes are not certified by this guide. The worked numerical calculations use the original numeric inputs, and the label examples explicitly concatenate a string.

When a documented text output is essential, TEXT explicitly converts numbers to text with a requested pattern. For numerical rounding, use ROUND and ordinary cell formatting. TO_TEXT converts numeric values while retaining their existing display formatting, which is a different goal from specifying a new decimal count.

Record the locale when comparing punctuation-sensitive results. The source explicitly notes that grouping separators vary by locale; its default suppression rule should not be read as a promise that every file uses commas. Unverified fractional precision, empty inputs and native error displays remain separate from the successful controls above.

• Google FIXED reference.
• Editorial testing standards.

Examples use fictional data, English function names and comma separators. Expected outputs are independent mathematical calculations or explicitly documented rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.