WorksheetFunction.Fixed Method
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
Syntax
expression.Fixed(Arg1, Arg2, Arg3)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Double | Number - the number you want to round and convert to text. |
| Arg2 | Optional | Variant | Decimals - the number of digits to the right of the decimal point. |
| Arg3 | Optional | Variant | No_commas - a logical value that, if TRUE, prevents FIXED from including commas in the returned text. |
Return Value
String
Remarks
- Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.
- If decimals is negative, number is rounded to the left of the decimal point.
- If you omit decimals, it is assumed to be 2.
- If no_commas is FALSE or omitted, then the returned text includes commas as usual.
-
The major difference between formatting a cell containing a number with the
Cellscommand (Formatmenu) and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with theCellscommand is still a number.