How to Round Numbers in Excel
The most common rounding mistake: clicking Decrease Decimal and assuming the number changed. It didn't — only the display did. Here's how to round the real value.
Last updated: August 2026
| Value | Rounded (2 dp) | |
|---|---|---|
| 3.14159 | → | 3.14 |
| 1247 | → | 1200 (to nearest 100) |
| 2.005 | → | 2.01 |
Why Decrease Decimal lies
The Decrease Decimal button is a format — it hides decimals but keeps them in the stored value. Add up a column of figures shown to 2 places and the total can be off by a cent, because Excel is still summing the full-precision numbers underneath. For accounts, that's a real problem.
Method — the ROUND functions
=ROUND(A2, 2)— nearest, to 2 decimals.=ROUNDUP(A2, 2)— always up;=ROUNDDOWN(A2, 2)— always down.- Negative digits round left of the decimal:
=ROUND(A2, -2)→ nearest 100. - Copy the column, then Paste Special > Values to bake in the rounded numbers.
The 1-click way — Tellsheet
Round Numbers rewrites the real values in a column — no helper formulas, no paste-special. Pick to nearest, always up, or always down, and the number of decimal places (use -1 for the nearest 10, -2 for the nearest 100). Every change previews first and runs on your computer. Pairs with Convert Text to Number and Group & Summarize.
Frequently asked questions
Why doesn't Decrease Decimal actually round?
It only changes the display; the stored value keeps its decimals, so sums of the visible figures can look wrong. Use ROUND or Tellsheet's Round Numbers to change the real value.
How do I round to the nearest 10 or 100?
Negative digits: =ROUND(A2, -1) for tens, -2 for hundreds. Round Numbers accepts negative places too.
How do I always round up or down?
ROUNDUP / ROUNDDOWN, or Round Numbers' up/down modes on a whole column.
What about banker's rounding?
ROUND rounds halves away from zero. If you need round-half-to-even for stats, that's a specialist case; for money and reporting, nearest/up/down covers it.
Related Excel guides
Round a column in one click
Round Numbers changes the real values — nearest, up, or down — right inside Excel, with a preview first.
Get Tellsheet free See pricing