Fixed Decimals

To round values to a certain number of decimal places:

  1. Select the cell(s) that you want to format.

  2. Go to the Format menu, and click Cells.

  3. A Format Cells window will appear.

  4. Click the Number tab.

  5. In the Category box, click Fixed.

  6. A list of fixed decimal types will appear in the Type box. Click on a type to select it. When you click on a type, a Sample will be displayed below.  

  7. After selecting a type, click OK.

  8. The decimal formatting will be applied to the selected cell(s). Note that the numbers will still be numerical values after the formatting is applied.

Note: To quickly access the number formatting window, go to the Format menu, and click Number formatting.

 

Fixed Decimal Formatting in Advanced Mode

To apply fixed decimal formatting in Advanced Mode:

  1. Select the cell(s) that you want to format.

  2. To increase the number of decimal places, click the Increase Decimal button (<-.00). Each time you click, the number of decimal places will increase by one.

  3. To lower the number of decimal places, click the Decrease Decimal button (->.0). Each time you click, the number of decimal places will decrease by one.

 

FIXED Function

FIXED(number, precision, no_commas)

Parameter

Description

number

number you want to fix

precision

number of decimal places; if omitted, will default to two decimal places

no_commas

if TRUE, result will have no commas; if FALSE or omitted, result will have commas

Users experienced in entering formulas may prefer to use the FIXED function. To use this function:

  1. Click on the cell you want the insert the fixed value into.

  2. Type in a formula. For example, for 10.00, type =FIXED(10, 2), or simply =FIXED(10).

  3. Press Enter. The value (result) of your formula will appear in the cell. Note that this result can be used in basic calculations (addition, multiplication, subtraction, division); however, it will not be included in totals and subtotals.

Examples:

Formula

Result

=FIXED(18)

18.00

=FIXED(18, 2)

18.00

=FIXED(18, 0)

18

=FIXED(18, -1)

20

=FIXED(-18, 2)

-18.00

=FIXED(255, -2)

300

=FIXED(1000, 0, TRUE)

1000

=FIXED(1000, 2, TRUE)

1000.00

=FIXED(1000, 2, FALSE)

1,000.00

=FIXED(10.2, 0)

10

=FIXED(10.7, 0)

11

=FIXED(10.5, 0)

11