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
FIXED(number,decimals,no_commas)
Number is the number you want to round and convert to text.
Decimals is the number of digits to the right of the decimal point.
No_commas is a logical value that, if TRUE, prevents FIXED from including commas in the returned text.
Remarks
The major difference between formatting a cell containing a number with the Cells command (Format menu) and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with the Cells command is still a number.
Example
The example may be easier to understand if you copy it to a blank worksheet.
Selecting an example from Help
|
|