FIXED in Excel: Decimal Text, Grouping and Numeric Totals

• Introduced: the first introduction version is not established by the reviewed official history.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official FIXED reference. Documentation and independent models; no native Excel execution or wider platform certification.

=FIXED(number,[decimals],[no_commas])

Negative decimals round to the left of the decimal point. The examples use the decimal point and comma grouping documented in the English reference. They do not certify output punctuation across every regional configuration.

Microsoft notes a maximum of 15 significant digits for numbers and a decimals setting as large as 127. Asking for more decimal places cannot restore significant digits that were not retained in the source value. Exact limit behavior and floating-point midpoint cases are outside these worked controls.

The reference’s final example contains a prose slip: FIXED(44.332) returns 44.33, consistent with two places to the right, although its description says left. The syntax, default and displayed result establish the intended rule.

Put 9876.543 in A2. Evaluate the following separately:

Suppressing grouping does not suppress the decimal point or turn the output into a number. The last row rounds the number to the nearest hundred before producing text.

With −9876.543 in A3, =FIXED(A3,-1,TRUE) gives -9880 in the same documented punctuation convention. Unlike DOLLAR’s illustrated currency style, this ordinary decimal output uses a minus sign.

Enter these quantities in D2:D5: 2.5, 1000, 0.126 and −4.75. In E2 use and fill down:

=FIXED(D2,2,TRUE)

The four outputs are 2.50, 1000.00, 0.13 and -4.75. In F2, ="Quantity: "&E2 produces Quantity: 2.50; fill down to produce the other labels.

The two decimal places can make a human-readable export consistent. They are a presentation choice, not evidence that the measurements were originally accurate to hundredths. Also, no_commas only controls numeric grouping; FIXED is not a general CSV writer that escapes every field, delimiter or embedded quote.

For those D2:D5 inputs, the original numeric sum is 997.876. =FIXED(SUM(D2:D5),2,TRUE) yields 997.88. A range of the E-column results contains text, so it should not replace D in numeric analyses.

Use =ISNUMBER(E2) to check the type: FALSE. =ISTEXT(E2) returns TRUE. Cell number formatting would leave D2 numeric instead of creating another text value.

Rounding individual rows can differ from rounding a total. Enter 1.004, 1.004 and 1.004 in H2:H4. Three =FIXED(H2,2,TRUE) outputs each read 1.00, while =FIXED(SUM(H2:H4),2,TRUE) reads 3.01, since the unrounded total is 3.012.

If numerical row rounding is required, put =ROUND(H2,2) in I2 and fill down. Summing I2:I4 gives numeric 3, which can then be formatted as 3.00. Choose the order consciously and retain the raw measurements for auditing.

Numeric strings can sort differently from numbers: text 1000.00 precedes 2.50 alphabetically, even though 1000 exceeds 2.5. Sort using D, the numeric source, when magnitude is the intended order.

If a later import really needs to reparse these strings, NUMBERVALUE can state the separator convention explicitly. That extra step cannot reconstruct precision discarded during FIXED rounding. Prefer keeping the original numeric column rather than serializing and reparsing it inside the same calculation chain.

Use ROUND for numeric rounding, DOLLAR for locale-dependent currency text and TEXT for a chosen format pattern. Invalid argument coercion and native extreme-value errors remain untested here.

• Microsoft FIXED reference.
• Editorial testing standards.

Expected outputs are independently calculated examples or documented rules, not captured native Excel results. Formulas use English function names and comma argument separators. Locale, rendering and boundary restrictions are stated where relevant.