FIXED
Formats a number as text with a fixed number of decimals
Syntax
FIXED(number, [decimals], [no_commas])
Parameters
- number: Required. The number you want to round and convert to text
- decimals: Optional. The number of digits to the right of the decimal point (default 2)
- no_commas: Optional. If TRUE, prevents FIXED from including commas
Example
=FIXED(1234567.89, 1, FALSE)