FIXED function

Show All

Hide All

This article describes the formula syntax and usage of the FIXED function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.

Description

Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.

Syntax

FIXED(number, [decimals], [no_commas])

The FIXED function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):

• 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.

Remarks

• Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.
• If decimals is negative, number is rounded to the left of the decimal point.
• If you omit decimals, it is assumed to be 2.
• If no_commas is FALSE or omitted, then the returned text includes commas as usual.
• The major difference between formatting a cell containing a number by using a command (On the Home tab, in the Number group, click the arrow next to Number, and then click Number.) and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with the Cells command is still a number.

Example

The example may be easier to understand if you copy it to a blank worksheet.

How do I copy an example?