﻿ FIXED function

# FIXED function

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)

Number     is the number you want to round and convert to text.

Decimals     is the number of digits to the right of the decimal point.

No_commas     is 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 to copy an example

1. Create a blank workbook or worksheet.

2. Select the example in the Help topic.

Note   Do not select the row or column headers.

Selecting an example from Help

3. Press CTRL+C.

4. In the worksheet, select cell A1, and press CTRL+V.

5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

 1 2 3 4
 A Data 1234.567 -1234.567 44.332 Formula Description (Result) =FIXED(A2, 1) Rounds the first number 1 digit to the right of the decimal point (1,234.6) =FIXED(A2, -1) Rounds the first number 1 digit to the left of the decimal point (1,230) =FIXED(-1234.567, -1, TRUE) Rounds the second number 1 digit to the left of the decimal point, without commas (-1230) =FIXED(44.332) Rounds the third number 2 digits to the left of the decimal point (44.33)

Applies To: Excel 2007

﻿