FIXED:
Formats a number as text with a fixed number of decimals
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.
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. 
• 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. 
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.