Excel FIXED Function

Using the Excel FIXED Function


The Excel FIXED function rounds a number to the specified number of decimals, formats the number in decimal format, using periods and commas, and returns the result as text.

See the TEXT function for increased flexibility and to apply various number formats.


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

Syntax Breakdown

Required. The number to be rounded and converted to text.

Optional. Number of digits to the right of the decimal. If omitted, the function assumes 2 decimal places. If the decimal argument is negative, then number is rounded to the left.

No Commas
Optional. Logical value. If TRUE, the function will not include commas in the returned text. If FALSE, or omitted, the function returns a number with commas included.

Usage Notes

FIXED converts a number to text with a fixed number of digits to the right of the decimal. When decimal places are specified, the function will round the number as needed.

In Excel, numbers can have up to 15 significant digits. Decimals, however, can be as large as 127 digits.