Round Excel Numbers Without a Formula: Display or Change

Yes. In Excel for Microsoft 365 on Windows, use a number format to display fewer decimal places without entering a formula: select the cells, then choose Home > Number > Decrease Decimal. This changes how the numbers look, not the values stored in the cells; permanently changing stored values without a formula requires a different, more consequential setting.

What rounding without a formula means

People usually mean one of two things when they ask how to round Excel numbers without a formula. They may want a cleaner display, such as showing 18.736 as 18.74, or they may need the underlying value itself to become 18.74. Those outcomes are not the same. Excel’s ordinary number formatting handles the first; it does not, by itself, replace the original number.

That distinction matters whenever another calculation uses the cell. A value formatted to show two decimal places can still contain more digits, and Excel normally calculates using the stored value rather than the shortened display. A total, comparison, or exported data file may therefore behave differently from what someone expects after looking only at the rounded screen value.

For most reports, invoices, and charts where the goal is readability, formatting is the safer choice. It preserves the original data and can be changed later. If a downstream system specifically requires rounded values, use a deliberate conversion method and keep a backup of the original data.

Display fewer decimal places with number formatting

The fastest method is the decimal-place buttons on the Home tab. Select the cells or range, and in the Number group choose Decrease Decimal until the display has the number of decimal places you want. Choose Increase Decimal to show more again. These controls alter the number format, not the cell’s stored value.

For more control, open Format Cells:

Select the cells to format.
On Windows, press Ctrl+1. Alternatively, use the dialog launcher in Home > Number. On Mac, Command+1 opens Format Cells; menu names and dialog layout can vary slightly by Excel version.
On the Number tab, choose Number, set Decimal places, and select OK. You can also choose Currency, Accounting, Percentage, or another suitable category if that matches the data.

For example, if a cell contains 18.736 and you set Number to two decimal places, it displays as 18.74. A cell containing 18.7 may display as 18.70, which is useful when a report should show a consistent number of decimal places. To remove decimal places, set the count to zero; Excel displays a rounded whole number rather than simply hiding the decimal portion.

Why the displayed number can differ from a calculation

Suppose A1 contains 1.234 and A2 contains 1.234. If both cells are formatted to show two decimal places, each appears as 1.23. But a total that adds the original values is 2.468, which may display as 2.47. Adding the two visible figures by hand gives 2.46. The difference arises because the cells still contain 1.234 each.

This is often appropriate: retaining precision in source data can make later calculations more accurate. It can also be surprising in a reconciliation where the displayed line items are expected to add exactly to the displayed total. Decide whether the requirement is to round each input before calculating, or merely to show rounded figures. Formatting alone meets only the display requirement.

Formatting affects appearances in worksheets and commonly in printed reports, but it does not rewrite the underlying number for formulas. Likewise, copying a formatted cell normally copies its number format along with other cell properties; it does not turn the displayed figure into a new rounded value. Check the formula bar or increase the decimal display to see whether more precision remains.

Permanently change values with Set precision as displayed

Excel has a workbook calculation option called Set precision as displayed. It makes stored numeric values conform to the precision shown by their number formats, so it can round values without putting a rounding formula in each cell. However, this is not just a visual setting: it can discard digits from numeric values throughout the workbook.

On Windows, use File > Options > Advanced. Scroll to When calculating this workbook, select the workbook if necessary, then check Set precision as displayed. Excel warns that precision may be lost. The option is saved with the workbook. In Excel for Mac, look under Excel > Settings (or Preferences) > Calculation for Use precision as displayed; the precise label or location can vary by release.

Before enabling it, save a separate copy. The setting can affect numbers across worksheets in that workbook, not just the range currently selected. A cell formatted with zero decimal places can lose its fractional part; a date or time value can also be affected because Excel stores dates and times as numbers. If you later show additional decimal places, discarded digits cannot be recovered from that workbook value. Restoring a prior file copy may be the only way to retrieve them.

Use this option only when workbook-wide loss of hidden precision is intended. It is generally a poor choice for a workbook that contains source measurements, detailed financial calculations, dates with times, or other data that may need its original precision later.

When a formula and Paste Values are safer

If only selected values must become rounded, a formula in a temporary column gives more control than changing precision for the whole workbook. With the original number in A2, enter =ROUND(A2,2) in B2; if A2 contains 18.736, the formula returns 18.74. Fill the formula down for the other rows, check the results, then copy the results and use Home > Paste > Paste Values to replace or populate the destination cells with fixed numbers.

This workflow does use a formula temporarily, so it is not a strictly formula-free process. Its benefit is scope: you choose which values to round and can preserve the original column until you have verified the converted results. Keep the source column or a backup if you may need the unrounded numbers later. The Paste Values command removes formulas from the pasted cells, leaving the calculated results.

For rounding to a whole number, change the second argument to zero: =ROUND(A2,0). For rounding to the nearest ten, use =ROUND(A2,-1). These examples assume the source value is in A2; Excel’s ROUND function rounds halfway cases away from zero. The number-format method is still more convenient if the goal is only to present the values with fewer digits.

Choose the right number of decimal places

The number of decimal places should follow the purpose of the data, not just the visual appearance of the sheet. Measurements may need several decimals to preserve meaningful precision; a summary may show fewer. Currency reports often display two decimal places, but the source system or business rules determine whether intermediate values should also be rounded. Formatting a currency value to two places does not automatically apply a two-decimal rounding rule to later calculations.

Also distinguish decimal places from significant figures. Showing two decimal places means two digits after the decimal point: 4.567 displays as 4.57. It does not mean two significant figures; that would require a different number of digits depending on the size of the value. Excel’s basic decimal-place buttons are designed to change displayed decimal places, not to express a scientific significant-figures policy.

Choose number formatting when a report needs a shorter display but calculations should retain full stored values.
Choose a controlled conversion when selected data must be rounded before it is used elsewhere.
Avoid Set precision as displayed unless you intentionally want the workbook’s stored values changed to match their displayed precision.

Common problems and checks

If Decrease Decimal appears to do nothing, confirm that the selected cells contain numbers and that you are changing the intended cells. Text that looks like a number may not respond as expected. A cell in General format may also show a different number of digits depending on its width and value; choose a specific number format and decimal-place count for consistent output.

If a value displays as ####, the column may be too narrow to show the chosen format. Widen the column or use a more compact number format; the hashes do not mean the value was rounded incorrectly. If a total differs from the sum of visible, rounded line items, inspect the source precision and decide whether each line item needs to be rounded before totaling.

For data shared outside Excel, do not assume that a rounded display guarantees the recipient gets rounded values. A workbook can retain hidden decimal digits. CSV files do not preserve Excel number formats in the same way as a workbook, so check the exported file itself and confirm its contents before using it in another system. When exact rounded output is required, create and verify a values-only result.

Frequently Asked Questions

Does Decrease Decimal change the actual number in Excel?
No. It changes the displayed number format. Excel continues to calculate with the value stored in the cell unless you use a separate conversion method.

How do I round a number to a whole number without a formula?
Select the cells and use Home > Number > Decrease Decimal until no decimal places are displayed. This rounds the appearance only. To change stored values, use a carefully scoped conversion or Set precision as displayed, understanding its workbook-wide effect.

Can I round only some cells permanently without affecting the workbook?
Yes, but number formatting alone will not do that. A common controlled method is to calculate rounded results in a temporary column, copy them, and paste values into the intended cells. Keep the originals until you have checked the results.

Why does my total not match the rounded numbers I see?
The displayed cells may retain extra decimal places. Excel calculates from those stored values, so the total can differ from adding the rounded figures shown on screen. Decide whether the calculation should use the original precision or rounded inputs.

Is Set precision as displayed reversible?
Changing the option back does not restore digits already removed from values. Save a separate workbook copy before enabling it; if precision is lost, use the backup or original source data to recover it.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.