### FIXED(number [,decimals] [,no_commas])

Returns the text string of a number rounded to a fixed number of decimal places.

 number 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) The type of comma format to use:True = commas will separate thousands, millionsFalse = no commas (default).

#### Remarks

 * This function returns numbers as text.* You can tell that this function returns a text string because the result is left-aligned. Numerical values are right-aligned by default.* The "number" can be a number, a reference to a cell containing a number or a formula that evaluates to a number.* If "decimals" < 0, then "number" is rounded to the left of the decimal point.* If "decimals" is left blank, then 2 is used.* If "decimal" is empty, then* Any numbers formatted with this function can still be used in numerical formulas because numbers entered as text are automatically converted to numbers when performing calculations.* Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.* You can use the DOLLAR function to return a text string of a number with the dollar formatting \$0,000.00.* You can use the TEXT function to return a text string of a number in any format.* For the Microsoft documentation refer to support.microsoft.com

 A B 1 =FIXED(1234.567,1) = 1234.6 =A2 = 1230 2 =FIXED(1234.567,-1) = 1230 =2*A2 = 2460 3 =FIXED(-1234.567,-1) = -1230 =2*1230 = 2460 4 =FIXED(12000.75,1,TRUE) = 12001 5 =FIXED(12000.75,1,FALSE) = 12000.8 6 =FIXED(44.332,2) = 44.33 7 =FIXED(44.332,) = 44.33 8 =FIXED(44.332) = 44.33 9 =FIXED("some text") = #VALUE!