Contact
12 programs
Explore the site

FIXED Function in Apple Numbers: Round and Format Numbers as Text

Text Intermediate Apple Numbers

Format and round numbers into fixed-decimal text in Apple Numbers, control thousands separators, use negative decimal places, and distinguish formatted text from calculations.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Apple Numbers. How formula examples are checked

Quick answer: =FIXED(6789.123,2) converts a number into text rounded to two decimal places. Under the English-language grouping shown in Apple’s examples, its expected result is "6,789.12". Use =FIXED(6789.123,2,TRUE) when you want the same decimal text without thousands-position separators. Apple FIXED documentation.

Verification status: Official Formulas and Functions Help edition 15.4 was checked on 2026-10-12, and the example arithmetic was independently checked with Python Decimal using the documented round-half-up rule. The table describes expected text outputs, not observed Numbers app results. Not executed in Apple Numbers. Genuine application screenshots are not included.

Purpose: fixed-decimal text, not a new numeric value

The FIXED function takes a number, rounds it, formats decimal places and optionally adds grouping separators. The result is a string. This matters: a cell with the numerical value 6789.12 formatted to show two decimals is still a number; a cell containing the text "6,789.12" from FIXED is not inherently the numeric input you want for later calculations. The text function suits output labels, exported summaries and human-readable reports. Retain the original numeric cell for totals, averages, comparisons and charts.

Apple describes FIXED as both a rounder and a text formatter, including negative values for the places argument (round to tens, hundreds or thousands). It is not a substitute for validating invoice currencies, implementing every jurisdiction’s financial rounding rules, or controlling how a receiving program parses numbers.

Apple’s exact syntax, optional arguments, and controls

=FIXED(num, places, no-commas)

Argument: num

Required
Yes

Officially documented input
Number value

Meaning
Number that will be rounded and converted to text.

Argument: places

Required
No

Officially documented input
Number value

Meaning
Decimal places; a negative value rounds to the left of the decimal point.

Argument: no-commas

Required
No

Officially documented input
Modal/Boolean value

Meaning
FALSE, 0 or omitted = include position separators; TRUE or 1 = omit them.

Apple explicitly calls places optional, but the consulted FIXED page does not give a numeric default for omitting it. For reproducible lessons, specify places explicitly (for example 2 or 0) instead of importing Excel’s documented two-place default without verification. Apple’s own examples confirm FIXED(12.4,0) gives the text "12", not an integer numeric result.

Rounding rule: Apple specifies round-half-up for FIXED; when a discarded most-significant digit is 5 or greater, it rounds up. The official examples include FIXED(12.5,0) → "13", FIXED(4,-1) → "0", and FIXED(5,-1) → "10". This guide avoids making a separate claim about negative exact halfway cases without an Apple example or native verification. Source: Apple’s FIXED function definition.

Regional notation: English help uses a period as the decimal marker and illustrates a comma as a thousands-position separator. Actual display conventions can vary with region. Apple’s functions overview also explains that formulas use semicolons rather than commas between arguments when a comma is the configured decimal separator. For instance, =FIXED(A2;2;TRUE) may be required under such settings. The TRUE/FALSE choice controls grouping; it does not override the region’s decimal symbol.

Version/platform scope: Help 15.4 is a documentation edition, not proof of the installed Numbers app release. The earliest release of FIXED and exact Mac/iPhone/iPad/web parity were not established in this research. Test a sample formula on the platform to make platform-specific guarantees.

Reproducible worksheet: present numbers in a report

Create a table named Formatting Test with header row and numeric cells in column A. Enter the following values as numbers, not quoted strings. Add the places value in B and the no-commas choice in C, then enter the formula in D2 and fill down to D7.

=FIXED(A2,B2,C2)

Row: 2

A: Number
6789.123

B: Places
2

C: No commas?
FALSE

Expected text in D (English grouping)**
"6,789.12"

Row: 3

A: Number
6789.123

B: Places
1

C: No commas?
TRUE

Expected text in D (English grouping)**
"6789.1"

Row: 4

A: Number
6789.123

B: Places
−2

C: No commas?
FALSE

Expected text in D (English grouping)**
"6,800"

Row: 5

A: Number
12.5

B: Places
0

C: No commas?
FALSE

Expected text in D (English grouping)**
"13"

Row: 6

A: Number
5

B: Places
−1

C: No commas?
TRUE

Expected text in D (English grouping)**
"10"

Row: 7

A: Number
42

B: Places
2

C: No commas?
FALSE

Expected text in D (English grouping)**
"42.00"

The quotation marks in the rightmost column identify a text string; they are not displayed as part of the string. The expected first row uses Decimal rounding from 6789.123 to 6789.12, followed by a thousands separator. In row 4, rounding to the nearest hundred takes 6789.123 to 6800, then adds grouping. Decimal rounding and text output were independently checked, but Numbers itself was not run.

Optional controls, written explicitly

Apple’s help demonstrates the following formulas. The outputs below are text values, not numbers:

=FIXED(6789.123,2)       → "6,789.12"  [expected; grouping]
=FIXED(6789.123,1,1)     → "6789.1"    [expected; without grouping]
=FIXED(6789.123,-2)      → "6,800"     [expected; round to hundreds]
=FIXED(12.4,0)           → "12"        [expected]
=FIXED(12.5,0)           → "13"        [expected; tie rounds up]
=FIXED(4,-1)             → "0"         [expected]
=FIXED(5,-1)             → "10"        [expected]

Because no-commas defaults to grouping included, the third argument can be omitted when that behaviour is desired. Because the official page does not explain the default for places, the examples explicitly supply a second argument even though Apple’s interface shows it as optional.

Advanced uses and comparisons

Consistent precision for a report: =FIXED(A2,2,TRUE) produces a text label with exactly two decimal places in the English examples, such as "42.00" for a numeric input of 42. This is useful for human-readable output or concatenation when consistent display width matters.

Round to hundreds or tens: With B2 as the number 6789.123, =FIXED(B2,-2) is expected to return "6,800" under English grouping. This changes both the rounding unit and the type of the result. If later calculations need 6800 as a number, retain the numeric data and use an appropriate numeric rounding formula instead of relying on text coercion.

Work with other tables: If the numeric source is B2 of a table named Amounts, you can reference Amounts::B2 when a fully qualified reference is needed. Apple confirms Table Name::cell style references in its cell-reference guide. For cross-table formulas prefer selecting the source cell through the formula editor to avoid ambiguous names.

FIXED versus ROUND: Both can round values, but FIXED returns formatted text; numeric rounding functions preserve a result suitable for arithmetic. The actual rounding method of any comparison function must be checked independently. Do not replace numeric prices in your source data solely with FIXED output, especially before summing transactions.

FIXED versus VALUE: Apple’s VALUE reference converts supported number-like text into a numeric value. If you’re exporting formatted text and later importing it as numbers, validate locale and accepted representations rather than assuming every grouping format is portable.

Troubleshooting and limits

Symptom or risk Explanation Action
A total or chart behaves unexpectedly FIXED produces text, not numeric arithmetic results. Keep original numeric cells for computations; use FIXED only for output presentation.
Groups of three digits appear unexpectedly no-commas is omitted, FALSE or 0. Supply TRUE or 1 to remove position separators.
Output has the wrong number of decimals The second argument is omitted or has an unintended value. Set places explicitly; the consulted Apple page does not state its omitted numeric default.
Formula separators cause a syntax error Regional decimal-comma settings change argument punctuation. Use semicolons between arguments where Apple’s regional rules require them.
Rounding differs at half values FIXED uses Apple’s stated round-half-up rule, which may differ from other systems. Compare the exact business rounding policy and test tie cases on target devices.
Negative decimal places appear to lose digits Negative places rounds left of the decimal (e.g. to hundreds). Use 0 or a positive place count if you need digits after the decimal.
A pasted number is stored as text The num argument expects a number value. Verify the cell’s actual type and source import; do not assume every currency-like string is accepted.

No maximum allowed places, exact overflow token, or first-supported application version was established from the consulted Apple page. Do not quote Excel’s numeric precision or error limits as Apple Numbers limits without evidence.

Excel and other spreadsheet compatibility

Microsoft documents Excel FIXED with number, optional decimals and optional no_commas, and says that omitting decimals assumes two. The Excel FIXED documentation also describes text output and its own numeric precision limits. Apple’s page separately confirms optional places, but does not explicitly identify its default there. Keep the explicit second argument when copying examples between programs and don’t assume identical regional display or rounding at every signed halfway value.

Google Sheets has formatting and conversion tools, but this guide has not validated a one-to-one FIXED implementation on a particular Google Sheets version. Never substitute Excel or Google Sheets behaviour for undocumented Numbers rules merely because a function name looks familiar.

Read Apple FIXED for authoritative signature and rounding examples, Apple’s functions overview for formula syntax and regional separators, Apple cell references for table syntax, Apple DOLLAR for a related financial-text formatting function, and Microsoft FIXED only for explicit Excel comparisons. No live on-site internal URL was asserted working because the site could not be fetched reliably in this session.

  • CHAR — continue with a related Apple Numbers calculation.
  • CODE — continue with a related Apple Numbers calculation.
  • CLEAN — continue with a related Apple Numbers calculation.
  • T — continue with a related Apple Numbers calculation.
  • REPT — continue with a related Apple Numbers calculation.

For a software-specific comparison: LibreOffice Calc FIXED. A shared name does not establish identical argument, error or version behaviour.

How this guide was checked

The linked official function documentation was reviewed on October 12, 2026. Apple’s Formulas and Functions Help 15.4 identifies the documentation edition, not a minimum Numbers release or a guarantee of historical platform parity. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Apple Numbers execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.