Skip to content
Google Sheets

FIXED function in Google Sheets

Formats a number with a fixed number of decimal places.

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

FIXED syntax and parameters

Three arguments, one required.

  • numbernumberRequired

    The number to format.

  • number_of_placesnumberOptional

    [ OPTIONAL ] - The number of decimal places to display in the result. If number has fewer than number_of_places significant digits, zeros will be appended. If it has greater than number_of_places significant digits, number will be rounded to the correct number_of_places rather than truncated.

  • suppress_separatorbooleanOptional

    [ OPTIONAL - 0 by default ] - Whether or not to suppress the thousands separator used in some locales (e.g. 1,000 becomes 1000). Separators will be present if this value is 0 or omitted, and absent otherwise.

FIXED examples

Formulas you'll actually reuse.

  1. One decimal place with thousands separators, as text:

    =FIXED(B2, 1)

    Result"1,250.0"

  2. No decimals and no separators — for an ID-style string:

    =FIXED(B2, 0, TRUE)

    Result"1250"

FIXED in Excel

Same name — your formula ports as-is.

Try FIXED in the playground

Edit the example — nothing to install.

Preloaded with the FIXED formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.