Excel Round to 2 Decimal Places: ROUND, Formatting and Pitfalls

To round a number to 2 decimal places in Excel, use =ROUND(A1, 2), where A1 is the cell holding your number. If you only need the number to look like it has two decimals, select the cells and use the Decrease Decimal button (or a Number format with 2 decimal places) instead, which changes the display but not the stored value.

That distinction between the displayed value and the stored value is where most rounding confusion comes from, so the rest of this guide covers both approaches and when each one is right.

The quick answer: the ROUND function

According to Microsoft’s ROUND function documentation, the syntax is:

=ROUND(number, num_digits)

• number is the value or cell you want to round.
• num_digits is how many digits to keep. When it is greater than 0, the number is rounded to that many decimal places.

So for two decimal places you always use 2 as the second argument. Microsoft’s own example rounds 23.7825 to two places, and the result is 23.78.

Step by step

1. Click an empty cell next to your data, for example B1.
2. Type =ROUND(A1, 2) and press Enter.
3. Drag the fill handle (the small square at the bottom-right of the cell) down to copy the formula to the rest of the column.
4. If the results show fewer than two decimals (for example 4.5 instead of 4.50), apply a Number format with 2 decimal places as well. ROUND changes the value. It doesn’t force trailing zeros to appear.

You can also wrap ROUND around any other formula, which is often the cleanest approach:

=ROUND(SUM(B2:B20) * 1.2, 2)
=ROUND(C2 / D2, 2)

Here are a few worked results, taken from the tutorials listed in the sources:

Formatting vs. rounding: which one do you need?

Microsoft’s guide Round a number to the decimal places I want describes two separate approaches:

• Change the number format. The Increase Decimal and Decrease Decimal buttons on the Home tab, or a Number/Currency format set to 2 decimal places, change how many digits are shown. The underlying value stays the same.
• Use a function. ROUND (and its relatives) produce a new value that really is rounded.

Why your total is off by a cent

Say three cells each contain 1.004 but are formatted to show 1.00. On screen they look like they should add up to 3.00, but Excel adds the real values and gets 3.012, which displays as 3.01 with 2 decimals. Nothing is broken. Excel is calculating with the stored numbers, not the ones you see.

If the visible numbers must add up exactly (invoices, financial statements), round each line with ROUND(..., 2) first and total the rounded values. Formatting alone won’t fix this.

Always rounding up or down: ROUNDUP and ROUNDDOWN

ROUNDUP and ROUNDDOWN take the same two arguments as ROUND, so 2 still means two decimal places (ZetCode).

• =ROUNDUP(A1, 2) always moves the value away from zero. The Bricks’ guide shows =ROUNDUP(45.781, 2) returning 45.79.
• =ROUNDDOWN(A1, 2) always moves the value toward zero, so 12.345 becomes 12.34 and 19.999 becomes 19.99, where ROUND would give 20.

These are useful when a business rule decides the direction, such as always charging the higher amount for shipping weight or never overstating a discount.

TRUNC: chop off extra decimals

=TRUNC(A1, 2) simply cuts the number off after two decimals. With positive and negative numbers it behaves like ROUNDDOWN, since both move toward zero. The main difference is that TRUNC’s digits argument is optional (it defaults to 0), while ROUNDDOWN requires it (Exceljet). INT is the one that behaves differently with negatives, because it rounds them away from zero.

Rounding to a cents increment: MROUND

Sometimes “2 decimal places” really means “the nearest 5 cents”. MROUND rounds to a multiple:

=MROUND(A1, 0.05)

Keep in mind that both arguments must share the same sign. A negative value needs a negative multiple, such as =MROUND(A1, -0.05), or Excel returns an error.

The “Set precision as displayed” option (use with care)

Excel has a workbook setting that makes every cell’s stored value match what its format displays. How-To Geek and other guides place it under File > Options > Advanced, in the When calculating this workbook section, as Set precision as displayed.

To turn it on:

1. Save a backup copy of the workbook first.
2. Go to File > Options > Advanced.
3. Scroll to When calculating this workbook and check Set precision as displayed.
4. Read the warning that data will permanently lose accuracy, then click OK only if you’re sure.

Several sources stress the same points:

• It applies to the entire workbook, not just the selected cells.
• The change is permanent. Unchecking the box later does not bring back the original digits. The only way to recover them is the original source data.

For most people a helper column with ROUND is safer, because the original data stays intact. If you then need to replace the originals, copy the ROUND results and use Paste Special > Values over the source column.

Common mistakes

• Using 1 instead of 2. The second argument counts decimal places, so =ROUND(A1, 1) gives one decimal place, not two.
• Expecting ROUND to add trailing zeros. =ROUND(4.5, 2) is still 4.5. Apply a 2-decimal number format to show 4.50.
• Rounding text. Numbers imported as text (often left-aligned, sometimes with a green triangle) need converting to real numbers before ROUND works on them.
• Rounding too early. In multi-step calculations, round the final result rather than every intermediate step unless a rule (such as per-line tax) requires otherwise. Rounding early compounds small errors.

Does this work in every version of Excel?

ROUND, ROUNDUP, ROUNDDOWN, TRUNC and MROUND are long-standing worksheet functions, and the sources above cover them for desktop Excel. Menu locations such as File > Options > Advanced can differ in Excel for the web and on Mac, and Microsoft occasionally moves settings around, so treat the menu paths here as accurate as of November 2026 and check Microsoft’s documentation if a button isn’t where you expect.