FIXED
Description
Rounds a number to the specified number of decimal places and formats the result as text.
Syntax
FIXED(
number
, [
decimals
], [
no_commas
])
- number: The number to format.
- decimals: The number of decimal places to use for the result.
- no_commas: Specifies whether to omit the thousands separator character. FALSE or Empty = include separators; TRUE = omit separators. The default is TRUE.
Example
Formula | Result |
|---|---|
=FIXED(A1)
Where cell A1 contains
$2451.00
.
| 2451.000 |
=FIXED(A1,4,FALSE)
Where cell A1 contains
1234567
.
| 1,234,567.0000 |