FIXED

Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.

Syntax

FIXED(number,decimals,no_commas)

Number    is the number you want to round and convert to text.

Decimals    is the number of digits to the right of the decimal point.

No_commas    is a logical value that, if TRUE, prevents FIXED from including commas in the returned text.

Remarks

• If decimals is negative, number is rounded to the left of the decimal point.
• If you omit decimals, your system locale setting will be used to determine the number of decimal places.
• If no_commas is FALSE or omitted, then the returned text includes commas as usual.

Example

Formula	Description (Result)
=FIXED(1234.567, 1)	Rounds the first number 1 digit to the right of the decimal point (1,234.6)
=FIXED(1234.567, -1)	Rounds the first number 1 digit to the left of the decimal point (1,230)
=FIXED(-1234.567, -1, TRUE)	Rounds the second number 1 digit to the left of the decimal point, without commas (-1230)
=FIXED(44.332)	Rounds the third number 2 digits to the left of the decimal point (44.33)