How to Round in Excel to 2 Decimal Places Correctly

Formulas & functions · Updated November 20, 2026

To round a number to two decimal places in Excel, use the ROUND function: if the value is in A2, enter =ROUND(A2,2) in another cell. To change only how a number looks, select the cells and use the decimal-place controls on the Home tab; that leaves the stored value unchanged.

What rounding to two decimal places means

Two decimal places means keeping the digits in the hundredths position: the second digit to the right of the decimal separator. Excel checks the next digit, in the thousandths position, to decide whether to leave the hundredths digit as it is or increase it. For example, 4.372 becomes 4.37, while 4.378 becomes 4.38. The number of digits displayed and the number of digits stored are separate matters in Excel, so it is useful to decide whether you need a rounded result or simply a shorter display.

Rounding is common when preparing prices, measurements, percentages, and summaries for presentation. It can also affect later calculations if you use a function such as ROUND to replace a value with a rounded result. In contrast, changing the displayed number format usually hides digits without removing them from the underlying value.

Use the ROUND function

ROUND takes two arguments: the number to round and the number of digits to keep. A positive second argument specifies decimal places, so 2 means two places. Assuming the original number is in A2, enter =ROUND(A2,2) to return the rounded value in the cell containing the formula. If A2 contains 12.346, the result is 12.35; if it contains 12.342, the result is 12.34.

The formula does not change A2. It produces a result in the formula cell, which you can use in other calculations or copy as a value if you need to replace the original data. To calculate a rounded amount from a different cell, change the reference. For example, with a measurement in B5, enter =ROUND(B5,2). The second argument stays 2 because the requested precision is two decimal places.

To apply the same calculation to a column, enter the formula alongside the first value, then use the fill handle—the small square at the lower-right corner of the selected cell—to copy it down. Excel adjusts relative references as it fills: a formula referring to A2 becomes one referring to A3 in the next row. Check a few results, especially at the bottom of a long list, before using them in a report.

Round using Excel’s number-format controls

If your goal is only to show two decimal places, formatting is quicker and preserves the original precision. Select the cells, open the Home tab, and use Increase Decimal or Decrease Decimal in the Number group until the display has two decimal places. The buttons change how many decimal digits are shown; they do not create a separate rounded result for subsequent calculations.

You can set an exact decimal-place count through the Format Cells dialog. Select the cells and press Ctrl+1 on Windows, choose the Number category, set Decimal places to 2, and select OK. In Excel for Mac, Command+1 opens Format Cells; dialog labels and ribbon arrangement can vary slightly by release. Excel for the web also provides number-format controls on the Home tab, although the precise arrangement may differ from the desktop app.

Formatting can make a value such as 7.1 appear as 7.10, which is useful for prices or other data that should consistently show hundredths. It can also make 7.146 appear as 7.15 while retaining 7.146 internally. If you click the cell and inspect the formula bar, you may see more digits than the grid displays. That is expected, not evidence that the format failed.

Choose between rounding and formatting

Use ROUND when the rounded number itself needs to feed another calculation, be exported as a rounded value, or meet a rule that requires calculations to a defined precision. Use formatting when you only need a clean display and want Excel to retain the underlying precision for later work. The difference matters when totals are calculated: a formatted value can look rounded while its hidden digits still contribute to a sum.

For example, suppose A2 and A3 each contain 1.004. If both cells are formatted to show two decimal places, each appears as 1.00, but their sum is 2.008 and may display as 2.01 when formatted to two places. If you instead round each input first, the rounded values are 1.00 and 1.00, and their total is 2.00. Neither approach is automatically right for every task; choose based on the calculation rules for your report or process.

For a total of the original values in A2:A3, enter =SUM(A2:A3) in another cell; it returns 2.008 for the example above. To round that total to two decimal places, use =ROUND(SUM(A2:A3),2), which returns 2.01. These formulas assume the two source values are in A2 and A3. If a business procedure requires each line to be rounded before summing, round the line values first and total those results instead.

How Excel decides which way to round

For ordinary ROUND calculations, a digit of 5 or greater in the next position causes the retained digit to increase; a digit below 5 leaves it unchanged. Thus, assuming the source number is in A2, =ROUND(A2,2) returns 3.46 when A2 is 3.456 and 3.45 when A2 is 3.454. Excel rounds halfway values away from zero: with A2 containing -3.455, =ROUND(A2,2) returns -3.46. This is worth noting because the direction for negative numbers may not match a casual interpretation of rounding down or up.

Excel stores many decimal fractions as binary floating-point approximations rather than as exact decimal quantities. As a result, a value produced by prior calculations may not be exactly the decimal midpoint it appears to be on screen. When a result seems surprising, inspect the source calculation and its full precision, rather than relying only on the displayed digits. Formatting the source to show more decimal places can help diagnose the issue.

Alternatives for always rounding up or down

ROUND follows the nearest-value rule. If you need a consistent direction instead, Excel has ROUNDUP and ROUNDDOWN. Assuming A2 contains the value, =ROUNDUP(A2,2) rounds away from zero to two decimal places, while =ROUNDDOWN(A2,2) rounds toward zero. For a positive value such as 2.341, these return 2.35 and 2.34 respectively. With a negative value, away from zero means a more negative result, so do not interpret ROUNDUP as always moving toward the larger number.

Another function, MROUND, rounds to a specified multiple rather than to a fixed count of decimal places. For instance, it can be useful when values must fall on increments such as 0.05. If A2 contains the amount, =MROUND(A2,0.05) rounds it to the nearest multiple of 0.05; this is different from simply keeping two decimal places. Check whether a multiple-based rule is actually required before choosing it.

For most standard two-decimal results, ROUND is the clearest choice. Avoid replacing it with a more specialized function unless you need a particular direction or increment. The name of the function and the intended rule should be clear to anyone who later reviews the workbook.

Common problems and checks

  • The formula appears as text: check whether the cell is formatted as Text or whether an apostrophe precedes the equals sign. Set the cell to General, re-enter the formula, and press Enter.
  • The result has no visible trailing zero: ROUND can return a numeric value of 5.2, even though it was rounded to hundredths. Format the result cell to show two decimal places if you need it to display as 5.20.
  • The answer looks unchanged: the number may already round to the same displayed value, or the cell may be showing fewer digits than the result contains. Increase the displayed decimal places to inspect it.
  • A total differs from the sum of visible lines: the lines may be formatted rather than rounded, so hidden digits remain in the calculation. Decide whether the rule applies to each line or only to the final total.
  • The formula gives an error: confirm that the referenced cell contains a number rather than text, and check that the formula has a comma between its arguments. Excel installations using a different regional list separator may display or require semicolons instead of commas.

These checks help distinguish a calculation problem from a display issue. If a workbook is shared with people using different regional settings, number separators and formula argument separators can vary. Excel normally interprets formulas according to the local settings, so the visible decimal and argument separators may not look identical on every computer.

Frequently Asked Questions

How do I round a number in Excel to 2 decimal places?
Assuming the value is in A2, enter =ROUND(A2,2) in another cell. This returns a numeric result rounded to hundredths.

How do I show two decimal places without changing the value?
Select the cells and adjust the decimal-place controls in Home > Number, or open Format Cells and set Decimal places to 2. This changes the display, not the stored value.

How do I make every number in a column round to two places?
Put a ROUND formula beside the first value, fill it down, and use the resulting column where a rounded value is needed. If you only want consistent display, select the column and set its number format instead.

Does Excel round 5 up or down?
With ROUND, a 5 in the first discarded position rounds away from zero. For positive numbers that means the retained value increases; for negative numbers it becomes more negative.

Why does my rounded number still show one decimal place?
ROUND returns a number, not a fixed-width text string. A numeric result such as 5.2 can still represent a value rounded to hundredths. Set the cell format to show two decimal places to display 5.20.

Can I round a total rather than each row?
Yes. Apply ROUND to the sum if the intended rule is to round only the final total. If the rules require each row to be rounded first, round each row and then total those rounded results; the answers can differ.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.