Spreadsheets store long decimals; humans read short ones. A lab value is 18.756 but the report column allows two places. A grade average lands at 87.444444 and the portal shows a whole number. Enter the value, set decimal places, and copy what you mean to show—not what Excel stored invisibly.
Rounding here is display rounding. It does not replace banker's rules in your accounting system, and it does not tell you whether to round before or after tax—that policy still lives with you.
Round 18.756 to two decimal places matches the defaults—18.76 if standard rounding, still worth a click when a PDF and your sheet disagree by a cent.
Round for the audience, not twice
Rounding twice is how dashboards drift: round each line, then sum, and wonder why the total differs from the boss's. Pick the step where rounding is allowed, run it once, paste. Percent lines often need the raw value first—15% of 240—then round the dollars if the slide needs integers.
Imported measurements sometimes need unit cleanup before rounding—2.5 kilograms in pounds—separate from how many decimals to show. Speed estimates use a different habit: distance at 45 mph for 2.5 hours.
- More decimal places is not more accurate if the input was already an estimate.
- Negative numbers round toward the same rules the browser uses—spot-check sign.
- Keep the unrounded source in a footnote when money matters.
The number rounding for reports note and the shorter rounding without losing meaning note pair well when a table looks almost right. Reference formatting, not legal or scientific sign-off.