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, millions
False = no commas (default).
|* 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
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top