To round a number to the nearest two decimal places in Excel, enter =ROUND(A1,2), replacing A1 with the cell containing your number. For example, =ROUND(23.7825,2) returns 23.78. If “round up” means the result must always move away from zero, use ROUNDUP instead.
ROUND chooses the nearest hundredth; ROUNDUP always rounds away from zero.
Round a cell to the nearest two decimal places
- Select an empty cell beside the number you want to round.
- Enter =ROUND(A1,2), changing A1 to the source cell.
- Press Enter.
The second argument, 2, tells Excel to keep two digits to the right of the decimal point.
| Original value | Formula | Result |
|---|---|---|
| 23.7825 | =ROUND(A1,2) | 23.78 |
| 23.786 | =ROUND(A1,2) | 23.79 |
| 7.5 | =ROUND(A1,2) | 7.50 when formatted to show two decimals |
| -1.475 | =ROUND(A1,2) | -1.48 |
Excel rounds a halfway value of .5 or greater away from zero. That is why =ROUND(-1.475,2) returns -1.48.
Free tools Windows power users keep installed
One-click scans. No signup required.
#1 Best Overall
- ULTRA-COMPACT DESIGN- Measuring just 4" x 2.25" x 0.3" and weighing in at only 1.23 oz, the HS-8VA is one of our smallest calculators, perfect for pockets, bags, desks and math on-the-go.
- BIG DISPLAY & EASY INPUT- 8-Digit LCD Display. Clear and easy-to-read screen ideal for everyday calculations at home, school, or office.
- GENERAL PURPOSE CALCULATOR – Ideal for a wide range of applications, from basic math to business and personal use, with memory keys for quick storage and recall.percentage, and square root.
- MEMORY KEYS- Features M+, M-, Memory Clear, and +/- key for efficient multi-step calculations.
- SOLAR WITH BATTERY BACK-UP – Reliable power with energy-efficient Solar Plus technology and battery back-up to keep you working without interruption.
Round a literal number without referencing a cell
You can put the number directly into the formula: =ROUND(23.7825,2). This returns 23.78. The first argument can be either a number or a cell reference.
Round every value in a column
Suppose the unrounded values are in column A, starting at A1:
- Enter =ROUND(A1,2) in B1.
- Press Enter.
- Select B1 and drag its fill handle down the column, or copy and paste the formula into the remaining cells.
Excel changes the references as it fills the formula: B2 uses =ROUND(A2,2), B3 uses =ROUND(A3,2), and so on.
When you really mean “always round up”
Many instructions use “round up” to mean “round to two decimal places.” In Excel, however, ROUNDUP has a specific meaning: it rounds away from zero, regardless of the next digit.
Use =ROUNDUP(A1,2).
| Value | Formula | Result |
|---|---|---|
| 3.14159 | =ROUNDUP(A1,2) | 3.15 |
| 3.14001 | =ROUNDUP(A1,2) | 3.15 |
| -3.14159 | =ROUNDUP(A1,2) | -3.15 |
For negative numbers, “away from zero” makes the result more negative. Therefore, ROUNDUP(-3.14159,2) returns -3.15, not -3.14.
Rank #2
- 8-digit LCD provides sharp, brightly lit output for effortless viewing
- 6 functions including addition, subtraction, multiplication, division, percentage, square root, and more
- User-friendly buttons that are comfortable, durable, and well marked for easy use by all ages, including kids
- Designed to sit flat on a desk, countertop, or table for convenient access
If you instead need to round toward zero, use =ROUNDDOWN(A1,2). For example, =ROUNDDOWN(3.14159,2) returns 3.14.
Use Excel’s Formula Builder
To use Formula Builder for ROUNDUP:
- Select an empty cell.
- Go to Formulas > Function > Formula Builder.
- Search for ROUNDUP and double-click it.
- Enter the cell or number in number.
- Enter 2 in num_digits.
- Press Return.
Round manually with a calculator
To round a number to the nearest hundredth without Excel:
- Keep the first two digits after the decimal point.
- Look at the third digit after the decimal point.
- If that digit is 0–4, leave the second decimal digit unchanged.
- If it is 5–9, increase the second decimal digit by 1.
For example, 23.7825 becomes 23.78 because the third decimal digit is 2. The number 23.786 becomes 23.79 because the third decimal digit is 6.
Recommended Free Tools
This is the nearest-value method, equivalent to ROUND(number,2). It is not the same as “always up.” If a requirement says every result must be rounded away from zero, use ROUNDUP.
Show two decimal places without changing the value
Sometimes the number only needs to look like it has two decimal places. Formatting does that without changing the stored value used in calculations.
Rank #3
- Easy-to-read 8 digit display
- Large 7-millimeter display height
- Three key memory
- Switch key +/-
- Power saving LCD
- Select the cells.
- On the Home tab, find the Number group.
- Select Increase Decimal or Decrease Decimal until two decimal places are displayed.
For exact control, select Home > Number > More Number Formats. Choose Number, set Decimal places to 2, and select OK.
For example, formatting may display a stored value of 12.3456 as 12.35, but Excel can still use 12.3456 in a subsequent calculation. Use ROUND or ROUNDUP when the underlying value must actually be changed.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Why Excel appears to round a number by itself
With General formatting, Excel may display fewer decimal places when the column is too narrow. The full number remains available in the formula bar and is still used in calculations.
If you see ######, that usually indicates that the column is not wide enough, rather than a rounding error. Widen the column by dragging its right edge, or double-click the right border of the column heading to resize it automatically.
Avoid using FIXED for numeric calculations
The FIXED function can show a specified number of decimal places, but it returns text: =FIXED(A1,2).
Rank #4
- COMPACT & PORTABLE DESIGN – Space-saving design that fits easily on any desk or in a briefcase, making it ideal for both home and office use.
- LARGE EIGHT-DIGIT DISPLAY – Clear and easy-to-read 8-digit display, perfect for everyday calculations, ensuring accurate results in home or office settings.
- GENERAL PURPOSE CALCULATOR – Ideal for a wide range of applications, from basic math to business and personal use.
- DUAL POWER SOURCE: Operates on solar power with battery backup to ensure reliable use in any lighting condition.
- DURABLE HARD COVER: Built-in protective case shields the calculator from scratches, drops, and everyday wear.
That makes it unsuitable when the result must remain a number for further calculations. Use ROUND, ROUNDUP, or ROUNDDOWN instead.
Use “Set precision as displayed” only with care
Excel also has a workbook-wide option that permanently changes stored values to match their displayed precision:
- Go to File > Options > Advanced.
- Under When calculating this workbook, select Set precision as displayed.
- Format the relevant cells to two decimal places through the Home tab’s Number section.
- Select OK.
This is not ordinary display formatting. It can permanently discard extra decimal digits and cause cumulative calculation inaccuracies. Use it only when the displayed precision is deliberately the correct precision for the workbook. In most cases, a separate ROUND formula is safer and easier to audit.
Which formula should you use?
| Requirement | Formula |
|---|---|
| Nearest two decimal places | =ROUND(A1,2) |
| Always away from zero | =ROUNDUP(A1,2) |
| Toward zero | =ROUNDDOWN(A1,2) |
| Only display two decimals | Format the cells through Home > Number |
| Two-decimal text for presentation | =FIXED(A1,2), with the result treated as text |
FAQ
What is the Excel formula to round up to two decimal places?
For normal rounding to the nearest hundredth, use =ROUND(A1,2). If the result must always round away from zero, use =ROUNDUP(A1,2).
How do I round 23.7825 to two decimal places in Excel?
Enter =ROUND(23.7825,2). Excel returns 23.78.
Does ROUND always increase a number?
No. ROUND selects the nearest value, so it can increase or decrease the number. ROUNDUP always rounds away from zero.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Best Value
- Mr. Pen 12-digit calculator is perfect for completing basic numerical calculations, making it ideal for office, primary school, market, or even home use. It features big, sensitive keys that are easy to press down and offer quick data entry.
- The mechanical switch buttons offer a responsive and satisfying click with each press, similar to a mechanical keyboard, improving the overall user experience and precision of data entry. Equipped with essential functions like memory recall, percentage calculation, and more, it meets a variety of computational needs.
- Mr. Pen calculator is portable and small in size at 6.2 x 4.4 inches, so it doesn't take up much desk space but is still comfortably sized for easy usage. It also has a large 12-digit display, increasing its visibility from any angle.
- Operating on just one AAA battery (not included), this calculator is designed with an automatic shutdown feature that activates after 10 minutes of inactivity, conserving battery life and ensuring longevity.
- Mr. Pen calculator is the perfect tool for quickly dealing with everyday calculation problems in various settings such as schools, offices, or even at home! It offers a fast, efficient, and user-friendly experience that makes it an ideal choice for anyone looking for a reliable calculator.
How do I round a whole Excel column to two decimal places?
Enter =ROUND(A1,2) in a neighboring cell, press Enter, then copy or fill the formula down. Excel adjusts the row reference for each value.
How do I show two decimal places without changing calculations?
Select the cells and use Home > Number, then adjust the decimal buttons. This changes the display only; the stored value remains unchanged.
Why does Excel show fewer decimal places than my original number?
General formatting may reduce the displayed digits to fit the column width. Check the formula bar to see the stored value, or apply a Number format with two decimal places.
The Bottom Line
Use =ROUND(A1,2) for ordinary rounding to the nearest two decimal places. Use =ROUNDUP(A1,2) only when “up” means always away from zero. If you only need two digits visible, format the cells instead—formatting changes appearance, not the value used in calculations.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Microsoft’s documentation covers these functions and decimal-formatting steps for Excel for Microsoft 365, Excel for Mac, Excel 2024, Excel 2021, Excel 2019, Excel 2016, and, for the decimal-place instructions, Excel Mobile. See the ROUND function documentation and Microsoft’s guide to rounding and displaying decimal places.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
