Rounds a number to a specified number of decimals and formats it as text with or without commas.
Syntax
FIXED(number, [decimals], [no_commas])Arguments
numberrequired
The number you want to round and convert to text.
decimalsoptional
The number of digits to the right of the decimal point; defaults to 2.
no_commasoptional
A logical value; if TRUE, commas are omitted from the result.
The FIXED function converts a numeric value into a text string using a fixed number of decimals. It allows you to control whether thousands separators are included in the final output.
=FIXED(1234.567, 1)→"1,234.6"Rounds the number to one decimal place and includes the comma separator.
=FIXED(1234.567, 0, TRUE)→"1235"Rounds to the nearest whole number and removes the comma separator.
Select the cell
Click on the cell where you want the formatted text to appear.
Enter the formula
Type =FIXED( followed by the number, decimal count, and comma preference, then press Enter.
It returns a text string, meaning you cannot perform mathematical calculations on the result directly.