| | | The "number" can be a number, a reference to a cell containing a number, or a formula that evaluates to a number. |
| | | The resulting number is rounded when necessary. |
| | | 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, i.e. you include the comma separator, then no decimal places are used. |
| | | The major difference between formatting a cell using (Format > Cells) and formatting it with this function is that using this function the result is converted to text. Using (Format > Cells) leaves the number as a number. |
| | | Any numbers formatted with this function can still be used in formulas as numbers entered as text are automatically converted to numbers when performing calculations. |
