The FIXED function 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.

FIXED takes 1 required argument and 2 optional arguments:

Syntax: FIXED(number, [decimals], [no_commas])

##### Using the FIXED function:
The arguments for the FIXED function are:
Argument Required? Description
number Required The number you want to round and convert to text.
decimals Optional The number of digits to the right of the decimal point.
no_commas Optional A logical value that, if TRUE, prevents FIXED from including commas in the returned text.
##### A few more things:
 • Numbers in 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. • If no_commas is FALSE or omitted, then the returned text includes commas as usual. • The major difference between formatting a cell containing a number by using a command and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with a cell formatting command is still a number.

### Summary

The FIXED function 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.