Last updated July 2026. To round numbers in Excel, use =ROUND(A2,2), where the first argument is the value and the second is how many decimal places you want. A positive second argument rounds to the right of the decimal point, 0 rounds to the nearest whole number, and a negative one rounds to the left: =ROUND(A2,-2) gives the nearest 100. ROUND goes to the closer value, while ROUNDUP and ROUNDDOWN always force one direction regardless of what comes after the cutoff.
Rounding matters most right after a conversion. When a PDF becomes a spreadsheet you often get amounts carrying more precision than the source document showed, or a column that looks correct but sums to a figure a cent or two off the printed total. Number formatting hides those digits without removing them, which is why a column of neat two-decimal cells can still add up wrong. This guide covers each rounding function, the decimal-place rules, rounding to the nearest 5 or 100, and the formatting trap that makes totals drift.
How do I round numbers in Excel?
Use the ROUND function: =ROUND(number, num_digits). Put the cell you want to round in the first argument and the number of decimal places in the second, so =ROUND(A2,2) turns 1234.5678 into 1234.57. Excel rounds to whichever value is closer, and a digit of exactly 5 rounds away from zero, so 2.145 becomes 2.15. Copy the formula down the column, then paste as values if you want the rounded figures to replace the originals.
The second argument is where most of the confusion lives, because it works in both directions from the decimal point. Microsoft's rule is straightforward once you see it laid out: greater than zero rounds to the right of the decimal, zero rounds to the nearest integer, and less than zero rounds to the left.
| Formula | num_digits | 1234.5678 becomes | Use it for |
|---|---|---|---|
=ROUND(A2,2) | 2 | 1234.57 | Currency, two decimal places |
=ROUND(A2,1) | 1 | 1234.6 | Rates, percentages |
=ROUND(A2,0) | 0 | 1235 | Whole units, headcount |
=ROUND(A2,-2) | -2 | 1200 | Nearest 100 |
=ROUND(A2,-3) | -3 | 1000 | Nearest 1000, reporting in thousands |
How do I round to 2 decimal places in Excel?
Enter =ROUND(A2,2) in an empty column next to your data and fill it down. That is the correct approach for money, because it changes the stored value to two decimals rather than only changing how it looks. If you instead select the column and click the decrease-decimal button, Excel keeps the full precision underneath and simply displays two places, which is exactly how a column of clean-looking figures ends up summing to something the eye cannot reconcile.
The distinction is worth being deliberate about. Format the cells when you want a tidy report and the underlying precision should be preserved. Use the ROUND formula when the rounded number is the real number from that point forward, such as an invoice total you are going to reconcile against a bank line. On converted data, the second case is usually what you want.
What is the difference between ROUND, ROUNDUP, and ROUNDDOWN?
ROUND moves the value to whichever side is closer. ROUNDUP always moves away from zero and ROUNDDOWN always moves toward zero, no matter what the following digit is, so =ROUNDUP(2.01,0) returns 3 and =ROUNDDOWN(2.99,0) returns 2. All three take the same two arguments, which means the negative num_digits trick works identically in each: =ROUNDUP(A2,-3) pushes any value up to the next thousand.
A few close relatives cover the remaining cases, and it is worth knowing which one does what before you reach for a nested formula.
| Function | What it does | Example | Result |
|---|---|---|---|
ROUND | Nearest value, ties go away from zero | =ROUND(2.5,0) | 3 |
ROUNDUP | Always away from zero | =ROUNDUP(2.1,0) | 3 |
ROUNDDOWN | Always toward zero | =ROUNDDOWN(2.9,0) | 2 |
MROUND | Nearest multiple you name | =MROUND(A2,5) | Nearest 5 |
CEILING | Up to the next multiple | =CEILING(A2,25) | Next 25 |
FLOOR | Down to the previous multiple | =FLOOR(A2,25) | Previous 25 |
INT | Down to the whole number below | =INT(-2.5) | -3 |
TRUNC | Chops decimals, no rounding | =TRUNC(-2.9) | -2 |
Watch the negative-number difference between INT and TRUNC. INT always goes down the number line, so it takes -2.5 to -3, while TRUNC simply removes the decimals and leaves -2. On a converted statement with credits and debits in one column, picking the wrong one shifts every negative amount by a full unit.
How do I round to the nearest 100 or 1000 in Excel?
Use a negative second argument: =ROUND(A2,-2) rounds to the nearest 100 and =ROUND(A2,-3) to the nearest 1000. Each additional negative step moves one more digit to the left, so -6 gives you the nearest million. Swap in ROUNDUP or ROUNDDOWN when the direction has to be fixed, which is common for budget figures that should never be understated.
This is the standard way to present a large schedule in thousands without touching the source column. Round into a new column, label it clearly, and keep the raw values in place so the detail is still auditable. It is the same rounding convention you see when a bookkeeping export is turned into a finished set of financial statements presented in thousands, where the underlying ledger stays at full precision.
How do I round to the nearest 5 or 0.5 in Excel?
Use MROUND, which rounds to the nearest multiple of whatever you give it: =MROUND(A2,5) for the nearest 5, =MROUND(A2,0.5) for the nearest half, and =MROUND(A2,0.25) for quarter hours. MROUND picks the closer multiple in either direction. If you need it to always go one way, use CEILING to push up to the next multiple or FLOOR to drop to the previous one.
Quarter-hour rounding is the everyday case here. Time pulled off a PDF timesheet lands as awkward decimals like 7.63 hours, and =MROUND(A2,0.25) turns that into 7.75 so the billing math is clean. One constraint to remember: MROUND expects the number and the multiple to share a sign, otherwise it returns #NUM!.
Why does my total not match after rounding?
Almost always because you formatted rather than rounded. Excel still adds the full stored precision, so a column displaying 10.12, 10.12 and 10.13 can total 30.38 while the visible figures suggest 30.37. Fix it by rounding with a formula so the stored value matches what you see, then summing the rounded column. The other cause is rounding at the wrong stage: rounding each line and then totaling gives a different answer than totaling first and rounding once.
Decide which of those two you actually want before you build the sheet. Invoice lines are normally rounded per line because each one is a real charge that has to stand on its own. An analytical total is usually better computed at full precision and rounded once at the end. Excel has a workbook-level setting called Set precision as displayed, under Options and then Advanced, that forces stored values to match the display, but it permanently discards the extra digits across the whole workbook, so leave it alone unless that is genuinely what you intend.
Why are my numbers rounded after converting a PDF?
Usually the cells inherited a general or whole-number format, so the decimals are present but hidden. Select the column, press Ctrl+1, choose Number, and set two decimal places to see whether the detail is still there. If the decimals genuinely did not survive the conversion, the problem is upstream in how the file was extracted, which is covered in more depth in this guide to converting a PDF to Excel without losing decimals.
There is a third possibility worth ruling out first. If the amounts came across as text rather than numbers, no rounding function will touch them and ROUND returns #VALUE!. Text values sit on the left of the cell by default and are ignored by SUM, so convert them properly using the steps in how to convert text to numbers in Excel before you round anything.
Rounding a converted file in the right order
Sequence saves rework. Fix the data types first, then round, then summarize, because rounding a column that is secretly text does nothing and summarizing before rounding bakes the discrepancy into your totals.
- Confirm the amounts are real numbers, not text, and that they right-align in the cell.
- Decide whether each line or only the final total needs rounding.
- Round into a new column with ROUND, ROUNDUP, or MROUND as the case requires.
- Paste as values over the working column once you are satisfied, keeping the raw import on a separate sheet.
- Total the rounded column and compare it against the figure printed on the original document.
That last check catches most extraction problems in a few seconds. If the rounded total ties to the PDF, the conversion was clean and the rest of your analysis rests on solid numbers. If it does not, the gap tells you where to look, and the wider post-conversion cleanup checklist walks through the usual causes. Rounding also interacts with percentage math, since a column of individually rounded percentages frequently sums to 99 or 101 rather than 100, which is explained in this guide to calculating percentages in Excel.
The cleaner the conversion, the less of this you have to do at all. A PDF to Excel converter that preserves numeric cells as numbers, decimals included, means rounding becomes a presentation choice rather than a repair job.