ExcelTextIntermediate

FIXED

Formats a number as text with a fixed number of decimals and optional comma separators.

Read the syntaxReview worked examplesOpen the spreadsheet app
=FIXED(number, [decimals], [no_commas])
Open Spreadsheet Explorer

This static page keeps the function indexed for search, while the spreadsheet app handles interactive exploration and saved formulas.

What the function does

Overview

Formats a number as text with a fixed number of decimals and optional comma separators.

The FIXED function converts a `number` into a text string, rounding it to a specified number of `decimals` and optionally applying comma separators. This function is useful when you need to display numbers in a consistent format as text, rather than as numeric values that might be subject to Excel's automatic formatting or precision changes. The `number` argument is the value you want to format. `decimals` (optional) specifies the number of digits to the right of the decimal point; if omitted, it defaults to 2. If `decimals` is negative, the number is rounded to the left of the decimal point. `ommas` (optional) is a logical value: `TRUE` prevents commas from being included in the returned text, while `FALSE` or omitted includes them. Since the output is text, you cannot perform mathematical calculations directly on the result of FIXED. It's best used for presentation or when integrating numbers into text strings where their numeric properties are no longer needed, ensuring a consistent visual representation.

Quick reference

Syntax

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

Inputs

Arguments

numberThe number you want to round and convert to text.
Example: 1234.567
decimals (optional)[Optional] The number of digits to the right of the decimal point. Defaults to 2.
Example: 0
no_commas (optional)[Optional] A logical value that, if TRUE, prevents FIXED from including commas in the returned text.
Example: TRUE

Formula patterns

Examples

1

Formatting a number with 2 decimals and commas

=FIXED(1234.567, 2)
number formattingtext conversion
2

Formatting a number with no decimals and no commas

=FIXED(9876.54, 0, TRUE)
data presentationstring output

Avoid these issues

Common Errors

1

#VALUE!

Cause: The 'number' argument is not a valid numeric value.

Fix: Ensure 'number' is a numeric value or a reference to a cell containing a number.

2

#NAME?

Cause: The function name is misspelled.

Fix: Correct the spelling of FIXED.

Platform support

Compatibility

Excel 2007+Google Sheets

Available in Excel 365 and earlier versions.

Source: Microsoft Support

Common questions

Frequently Asked Questions

Formats a number as text with a fixed number of decimals and optional comma separators.

number: The number you want to round and convert to text. decimals: [Optional] The number of digits to the right of the decimal point. Defaults to 2. ommas: [Optional] A logical value that, if TRUE, prevents FIXED from including commas in the returned text.

#VALUE!: Ensure 'number' is a numeric value or a reference to a cell containing a number. #NAME?: Correct the spelling of FIXED.