# 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. If no_commas is FALSE or omitted, then the returned text includes commas as usual.

- Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.
- If decimals is negative, number is rounded to the left of the decimal point.
- If you omit decimals, it is assumed to be 2.

**Remarks**

The major difference between formatting a cell containing a number with the **Cells** command (**Format** menu) and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with the **Cells** command is still a number.

**Examples**

`FIXED(1234.567, 1)`

equals "1234.6"

`FIXED(1234.567, -1)`

equals "1230"

`FIXED(-1234.567, -1)`

equals "-1230"

`FIXED(44.332)`

equals "44.33"