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

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

numberThe 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, millions
False = 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.office.com

 AB
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! 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top