FIXED function
Summary
Formats a number as text with a fixed number of decimals
Syntax
FIXED(number, [decimals], [no_commas])
The FIXED function syntax has the following arguments:
• 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.
• No_commas Optional. A logical value that, if TRUE, prevents FIXED from including commas in the returned text.
• 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.
• No_commas Optional. A logical value that, if TRUE, prevents FIXED from including commas in the returned text.
Example
=FIXED(A2, 1)
=FIXED(A2, -1)
=FIXED(A3, -1, TRUE)
=FIXED(A4)
=FIXED(A2, -1)
=FIXED(A3, -1, TRUE)
=FIXED(A4)