To round values to a certain number of decimal places:
Select the cell(s) that you want to format.
Go to the Format menu, and click Cells.
A Format Cells window will appear.
Click the Number tab.
In the Category box, click Fixed.
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.
After selecting a type, click OK.
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:
Select the cell(s) that you want to format.
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:
Click on the cell you want the insert the fixed value into.
Type in a formula. For example, for 10.00, type =FIXED(10, 2), or simply =FIXED(10).
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 |