If A2 contains a percentage such as 12.5%, use =ROUND(A2*100,0)/100 to round it to 13% as a numeric value; format the result as a percentage with zero decimal places. If you only want to change how the original value looks, use Home > Number > Decrease Decimal until no decimal places are shown.
Choose between rounding a value and changing its display
Excel stores a percentage as a decimal fraction: 12.5% is stored as 0.125, and 100% is stored as 1. This distinction explains why there are two different ways to make a percentage appear as a whole number. Formatting changes what Excel displays, while a rounding formula changes the number stored in a cell.
For a report, chart label, or worksheet where the underlying precision should remain available, use percentage formatting. A cell containing 12.5% can display as 13% while retaining its original 12.5% value for later calculations. If the rounded result itself must feed into another calculation or be exported as a rounded number, use a formula.
- Use formatting when the goal is a cleaner display and you want to preserve the original precision.
- Use a formula when later calculations must use the rounded percentage rather than its more precise source value.
- Use a text result only when you need a fixed label such as 13% and do not need to calculate with it.
Show percentages with no decimal places
In Excel for Microsoft 365 on Windows, select the percentage cells, open the Home tab, and look in the Number group. If the cells are already formatted as percentages, click Decrease Decimal until the displayed value has no digits after the decimal point. For example, 12.5% will display as 13%. Depending on the current format, the button may need to be clicked more than once.
If the values are not yet percentage-formatted, select them and choose Home > Number > Percent Style. Excel applies percentage formatting; then use Decrease Decimal to remove displayed decimal places. You can also open the Format Cells dialog with Ctrl+1, choose the Percentage category, and set Decimal places to 0. On Mac, use the Home tab’s number-format controls or press Command+1 to open Format Cells; ribbon labels can vary slightly by release.
Formatting does not perform rounding on the stored value. If a formula later sums, compares, or multiplies those cells, Excel generally uses the full underlying values. For example, three percentages that each display as 33% could still add to 100% or 99.9%, depending on their original values. That is not necessarily an error; it is a difference between the displayed precision and the stored precision.
Round the numeric percentage with a formula
Suppose A2 contains 12.5% as a true Excel percentage, not the number 12.5. In B2, enter =ROUND(A2*100,0)/100. The multiplication converts the stored fraction into percentage points, ROUND rounds those points to an integer, and dividing by 100 converts the result back to Excel’s percentage representation. The result is 0.13, or 13% when B2 is formatted as a percentage.
Copy the formula down the column to calculate a rounded result for each row. Format the output cells as Percentage with zero decimal places so the result is easy to read. The formula and the display format serve different purposes: the formula determines the numeric result, while the format adds the percent sign and controls the visible decimal places.
For instance, if A2 is 12.4%, the formula returns 0.12, which displays as 12%. If A2 is 12.5%, it returns 0.13, or 13%. Excel’s ROUND function rounds a halfway value away from zero, so a value exactly halfway between two whole percentage points does not use the “round half to even” method used in some other contexts.
Understand what ROUND is rounding
The second argument of ROUND specifies how many decimal places to keep in the number being rounded. In a percentage cell, one displayed percentage point corresponds to 0.01 in the stored decimal fraction. So rounding a true percentage to a whole percentage point can also be done by rounding its stored value to two decimal places.
With the percentage value in A2, =ROUND(A2,2) also changes 12.5% to 13%. This works because A2 stores 12.5% as 0.125, and rounding 0.125 to two decimal places produces 0.13. The earlier formula makes the conversion into percentage points more explicit; this shorter version is convenient when the input is definitely a normal Excel percentage.
Do not use =ROUND(A2,0) for a percentage stored as a fraction if your goal is the nearest whole percentage point. For 12.5%, Excel would round 0.125 to 0, which is 0% when displayed as a percentage. The formula would be valid Excel syntax but would round the stored fraction to a whole number, not the percentage points shown to a reader.
Choose rounding up, down, or to the nearest point
ROUND uses the nearest value. If the task calls for a consistent direction instead, ROUNDUP and ROUNDDOWN are available. ROUNDUP moves a nonzero value away from zero; ROUNDDOWN moves it toward zero. For positive percentages, that means ROUNDUP always goes to the next higher whole percentage point, while ROUNDDOWN drops the fractional percentage point.
With a true percentage in A2, =ROUNDUP(A2*100,0)/100 rounds upward to the next whole percentage point. For 12.1%, the result is 13%. With the same A2 input, =ROUNDDOWN(A2*100,0)/100 returns 12%. Format either result as a percentage with zero decimal places. These functions are useful when a rule explicitly requires upward or downward rounding; they are not substitutes for ordinary nearest-value rounding when that is what the calculation calls for.
For negative percentages, the direction may be less intuitive: ROUNDUP means away from zero, not simply toward a larger number. Thus, upward rounding of a negative value can make it more negative. Check the intended rule carefully if the data can include negative rates or changes.
Check the input format before rounding
A frequent source of mistakes is mixing percentage fractions with whole-number percentage points. If a cell displays 12.5% after being entered as 12.5%, its stored value is 0.125. If a cell contains the plain number 12.5 and is not percentage-formatted, it stores 12.5. These inputs need different formulas because they represent the same-looking idea in different ways.
For plain percentage points such as 12.5 in A2, =ROUND(A2,0) returns 13. If you want that result displayed as 13%, you can apply a custom number format that appends a percent sign, but take care: applying ordinary Percentage format to the number 13 will display 1300%, because Excel interprets 13 as 1300%.
Most worksheet data is easiest to maintain when percentages are entered as true percentages, such as 12.5%, and then formatted consistently. If importing data from another system, verify whether values such as 12.5 mean 12.5% or whether values such as 0.125 represent the percentage. Check a couple of known records before filling formulas down a large dataset.
Keep a rounded result numeric when calculations matter
A numeric result is usually preferable if you may need to add, compare, chart, or otherwise calculate with the rounded percentage. With a true percentage in A2, =ROUND(A2*100,0)&CHAR(37) returns the text 13% for an input of 12.5%. CHAR(37) supplies the percent character. The result looks right, but it is text, so other formulas cannot treat it as a numeric percentage without converting it first.
Formatting a numeric result is more flexible: the value remains available for arithmetic, and the percent sign is supplied by the number format. Also, avoid replacing original data unless that is genuinely required. Keeping the source percentage in one column and the rounded result in another makes the transformation visible and allows someone to check or revise it later.
Common problems and quick checks
- The result is 0%. Check whether you used ROUND with zero decimal places on a stored percentage fraction. For whole percentage points, round to two decimal places in the fraction, or convert to percentage points as shown above.
- The result shows 1300%. The input may be the plain number 13, and Percentage format multiplies that value by 100 for display. Confirm whether the input is 0.13 or 13 before choosing a formula and format.
- The display changes but calculations do not. You probably changed the number format only. That is expected: formatting does not replace or round the stored value.
- Rounded percentages do not add to 100%. Rounding each category separately can make displayed totals differ from 100%. For example, three equal shares of 33.33% each display as 33%, totaling 99%. Keep full precision for totals, or explain that displayed components are independently rounded.
- A formula appears as text. Check that the cell is not formatted as Text and that the formula begins with an equals sign. Changing the format to General and re-entering the formula can help.
Frequently Asked Questions
How do I round a percentage to a whole number in Excel?
For a true percentage in A2, use =ROUND(A2*100,0)/100 and format the result as Percentage with zero decimal places. To change only how A2 appears, use Percentage formatting and decrease the displayed decimal places instead.
How do I show 12.5% as 13% without changing the value?
Select the cell, choose Percentage formatting if needed, then use Home > Number > Decrease Decimal until no decimal places are visible. The cell still retains its original underlying value of 12.5%.
Why does ROUND(A2,0) turn 12.5% into 0%?
Excel stores 12.5% as 0.125. ROUND(A2,0) rounds that fraction to the nearest whole number, which is 0. To round to whole percentage points, round the fraction to two decimal places or convert to percentage points first.
Does Excel round .5 up for percentages?
ROUND rounds halfway values away from zero. Thus a true percentage of 12.5% rounds to 13% when rounded to a whole percentage point. For negative values, halfway rounding is also away from zero.
Can I round a percentage and keep it usable in calculations?
Yes. Use a numeric rounding formula and format its result as a percentage. Avoid joining the number to a percent sign with a text formula if you need to use the result in later arithmetic.
Related
- Excel MAX Between Two Dates: Find the Highest Value
- Excel Material List Template: Plan, Price, and Track
- Excel List Template Free? Where to Find and Use One
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel COUNTIF for Text That Contains a WordTo count cells that contain a particular word or phrase anywhere in their text, use Excel’s COUNTIF function…
- Add M to a Number in Excel: Formula and FormattingTo add an M after a number in Excel, apply a custom number format such as #,##0"M" to…
- Excel Copy Data Validation to Other Cells the Right WayTo copy only a cell’s data validation in Excel for Microsoft 365 on Windows, copy the cell, select…
- How to Copy in Excel Without Formulas: Keep ValuesTo copy the results of formulas without copying the formulas themselves in Excel for Microsoft 365 on Windows,…
- SUBTOTAL Formula for Visible Cells in Excel: How It WorksTo calculate a total for visible rows in Excel, use =SUBTOTAL(109,B2:B100), replacing the range with your data. The…
- Excel Formula for Roman Numbers: A Complete GuideThe Excel formula to convert a number to a Roman numeral is =ROMAN(number), and to convert a Roman…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.