Using the Excel FIXED Function
SummaryThe Excel FIXED function rounds a number to the specified number of decimals, formats the number in decimal format, using periods and commas, and returns the result as text.
See the TEXT function for increased flexibility and to apply various number formats.
Syntax=FIXED (number, [decimals], [no_commas])
Required. The number to be rounded and converted to text.
Optional. Number of digits to the right of the decimal. If omitted, the function assumes 2 decimal places. If the decimal argument is negative, then number is rounded to the left.
Optional. Logical value. If TRUE, the function will not include commas in the returned text. If FALSE, or omitted, the function returns a number with commas included.
Usage NotesFIXED converts a number to text with a fixed number of digits to the right of the decimal. When decimal places are specified, the function will round the number as needed.
In Excel, numbers can have up to 15 significant digits. Decimals, however, can be as large as 127 digits.