To round a number to two decimal places in Excel, use the ROUND function: with the value to round in A2, enter =ROUND(A2,2) in another cell. If you only want the cell to look like it has two decimals, select it and choose Home > Number > Decrease Decimal or set its number format to two decimal places.
Two ways to show two decimal places
Excel can change a number itself, or change only how the number appears. These are different operations, even though both can make a cell display two digits after the decimal point.
- Use a formula when later calculations should use the rounded result.
ROUNDreturns a new numeric value rounded to the specified number of digits. - Change the number format when you want a consistent visual display but want to retain the original value for calculations. The cell still contains its full underlying value.
For example, a cell containing 8.746 can be formatted to display 8.75, while its stored value remains 8.746. If a formula rounds that value to two decimal places, the result is numerically 8.75. Choose based on what subsequent calculations, exports, or reports need—not just on what looks right on screen.
Round a value with the ROUND formula
In Microsoft Excel for Microsoft 365 on Windows, click the cell where you want the rounded result, type the formula, and press Enter. With the original number in A2, use =ROUND(A2,2). If A2 contains 3.456, Excel returns 3.46. The first argument is the number or cell reference; the second is the number of digits to round to. A positive 2 means two digits to the right of the decimal point.
For a column, enter the formula in the first result row, then fill it down using the fill handle at the lower-right corner of the cell. For example, with unrounded values in A2:A20, enter =ROUND(A2,2) in B2 and copy it down through B20. Each row then rounds the corresponding value in column A. The source values remain unchanged.
You can also round a calculation directly. With quantity in A2 and unit price in B2, enter =ROUND(A2*B2,2) in C2. If A2 is 3.333 and B2 is 4.50, the unrounded product is 14.9985 and the formula returns 15.00. This is useful when the result itself—not just its display—must be rounded to cents.
Set cells to display two decimal places
To alter appearance without replacing the underlying values, select the cells and use the ribbon. On Windows, go to Home > Number and click Decrease Decimal or Increase Decimal until two decimal places are shown. The buttons adjust the displayed precision; they do not calculate a rounded value for use in other formulas.
For an exact setting, select the cells, open the Number Format options in the Home tab’s Number group, choose More Number Formats, and select Number. Set Decimal places to 2, then confirm. You can also press Ctrl+1 on Windows to open Format Cells and choose Number, then set Decimal places to 2. The same Number Format choices are available in Excel for Mac, although ribbon layout and keyboard shortcuts can differ by version. In Excel for the web, use the Home tab’s number-format controls; the exact arrangement may vary with the window width.
A two-decimal number format can add trailing zeros as well as hide extra digits. For example, values such as 4, 4.5, and 4.567 can appear as 4.00, 4.50, and 4.57. That consistent appearance is often useful in price lists and reports. It does not mean that Excel has changed 4.567 to 4.57 as a stored value.
Choose the method that fits the calculation
Use formatting when the goal is presentation: a report may need all amounts to appear with two digits, while formulas should still use the most precise available values. Use ROUND when the value passed to the next calculation must actually be rounded. This distinction matters in totals, rates, and multi-step calculations.
Suppose several line items have fractions of a cent. Formatting each line to two decimals can make the sheet look as if each amount has been rounded, but a total may still add the hidden digits. That total can differ by a cent from the sum of the visible line amounts. If the business rule requires each line to be rounded before it is added, put a rounding formula in each line’s calculation, then total those rounded results. If the rule requires rounding only the final total, keep the more precise line values and round the total instead. The spreadsheet cannot determine which policy is correct; follow the applicable accounting or reporting requirement.
Also decide whether to overwrite source data. A separate result column is usually safer because it preserves the original values and makes the transformation visible. Replacing source values can make later auditing or recalculation difficult.
Other rounding functions and negative digits
ROUND rounds to the nearest specified place. In ordinary midpoint cases it rounds away from zero: for example, with 1.235 in A2, =ROUND(A2,2) returns 1.24; with -1.235 in A2, the corresponding formula returns -1.24. This is different from always rounding upward or always cutting off extra digits.
With a value of 2.341 in A2, =ROUNDUP(A2,2) returns 2.35, while =ROUNDDOWN(A2,2) returns 2.34. ROUNDUP moves away from zero; ROUNDDOWN moves toward zero. They are not synonyms for “round to the nearest” and should be used only when that directional rule is intended.
The second argument can also be negative to round to the left of the decimal point. With 1,234 in A2, =ROUND(A2,-2) returns 1,200, rounding to the nearest hundred. A zero digit argument rounds to the nearest integer. These options are handy for estimates, but they do not change the number-format display setting.
Common problems and misconceptions
- “I changed the decimals, but my total did not change.” That is expected when you changed only the number format. The total formula still uses the underlying values.
- “The result shows 2 decimals, so it must be rounded.” A display with two decimals does not prove that the stored value has been rounded. Check the formula bar or use a rounding formula if the actual value matters.
- “My rounded numbers add up differently from the total.” The total may be calculated from hidden decimal digits, while the displayed line items look rounded. Decide whether to round individual entries or only the final sum.
- “A value ending in 5 behaved unexpectedly.” Confirm the actual stored value and its precision. A displayed 1.235 might contain additional digits that are hidden by formatting, so the value being rounded may not be exactly the apparent number.
Excel stores many decimal fractions using binary floating-point values, so calculations can carry tiny precision differences. That does not usually affect ordinary two-decimal display, but it can matter in formulas that depend on exact comparisons or repeated calculations. If the required rule is to work with rounded cents at each step, explicitly round at the appropriate point rather than relying on what the cells show. Avoid rounding every intermediate result automatically: it can accumulate differences and change the final answer.
Displaying a fixed number of decimal places
A standard Number format with two decimal places is usually the clearest choice for a column of numeric values. If you need a different visual convention, the Format Cells dialog also offers options such as currency and accounting formats. Those formats affect presentation—currency formats can add a symbol and control alignment—but they do not by themselves round the stored number for subsequent calculations.
Be careful when converting numbers to text. A text representation can be convenient for labels, but it is no longer an ordinary numeric value for arithmetic. For calculations, keep the result numeric and apply a number format. If a downstream system specifically requires a text string with two digits, create that text as a separate output and retain the numeric source column.
Formatting can also be useful before printing or sharing a workbook: it makes columns easier to scan and avoids inconsistent-looking values. But if someone copies values into another program, exports data, or uses the workbook as a source for further analysis, do not assume that the displayed precision travels with the underlying value. Explain whether the figures are merely formatted or mathematically rounded.
Frequently Asked Questions
How do I round a whole column to two decimal places?
Use a helper column. If the original values are in A2:A20, enter =ROUND(A2,2) in B2 and fill the formula down to B20. If you only need a visual change, select A2:A20 and set the number format to two decimal places instead.
Does changing decimal places change the value in Excel?
No. The Increase Decimal and Decrease Decimal buttons and number formats change how a value is displayed. A function such as ROUND creates a rounded numeric result, which you can then use in other calculations.
How can I make Excel always show two digits, including zeros?
Format the cells as Number and set Decimal places to 2. Values like 6 and 6.4 will then display as 6.00 and 6.40. This affects appearance, not the stored values.
Should I round each row or only the final total?
It depends on the rule governing the calculation. Rounding each row first can produce a different total from adding precise values and rounding once at the end. Use the required policy consistently and make the rounding step explicit in the workbook.
Can I round to the nearest whole number or hundred?
Yes. In ROUND, use 0 for the nearest whole number, -1 for the nearest ten, or -2 for the nearest hundred. A positive digit count, such as 2, rounds to two decimal places.
Related
- Excel Middle Years Academy: What Families Should Know
- Excel Middle Row Selection: Find and Select the Center Row
- Excel Power Query: Combine Columns Without Losing Data
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- XLOOKUP Excel Column Match: Find a Column by HeaderTo match a value in an Excel column and return a value from another column, use XLOOKUP with…
- Find and Replace Formula in Excel: SUBSTITUTE or REPLACEIn Excel, use SUBSTITUTE to replace matching text inside a cell, or REPLACE to replace characters at a…
- SUMIF Formula Criteria Examples for Excel: Rules and TipsUse Excel’s SUMIF function to add values that match one condition, such as a product name, a minimum…
- Excel Formula Showing Instead of Result? Causes and FixesIf Excel is showing a formula instead of its result, first check whether Show Formulas is turned on;…
- DAX Formula to Concatenate Text in Power BIIn Power BI, use the DAX & operator to join text: Customers[FirstName] & " " & Customers[LastName]. Use…
- Excel Percentage Difference Formula: How to CalculateFor the percentage difference between two nonnegative values in Excel, use =ABS(B2-A2)/AVERAGE(A2,B2), then format the result as a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.