Excel functions / Text

FIXED function

A number as text, rounded to a set number of decimals, with or without commas.

Syntax

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

Arguments

When to use it

FIXED turns a number into text rounded to a set number of decimals, with thousands separators unless you ask for none. Like DOLLAR, it is for putting numbers into sentences and labels.

Examples

  1. Two decimals with separators

    ABC
    1Value
    21234.5671,234.57

    In C2: =FIXED(A2, 2) → 1,234.57

    Try this example

  2. No separators

    ABC
    1Value
    21234.5671234.6

    In C2: =FIXED(A2, 1, TRUE) → 1234.6

    Try this example

Common mistakes

FIXED in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try FIXED in the playground

Related functions