FIXED

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) A logical value indicating the type of comma format to use: False (or 0) = no commas (default) True (<> 0) = commas will separate thousands, millions

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.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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!