FIXED()
Syntax. FIXED(number,decimals,no_commas)
Definition. This function converts a numeric value into text with a fixed number of decimal places.
Arguments
number (required). The numeric value you want to convert into text.
decimals (optional). The number of digits to the right of the decimal point.
no_commas (optional). A logical value. If no_commas is TRUE, the FIXED() function does not display commas in the returned text.
Background. Like the DOLLAR() function, the FIXED() function rounds the number and converts it into text. The decimal places indicate whether a value is rounded or, if it is not, how many decimal places the value should have.
In Excel, numbers can have a maximum of 15 digit places. The maximum valid value for decimal places is ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
