Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to round percentage values to two decimal places in Excel?

Normally we can adjust a percentage value’s decimal places with the Increate Decimal feature or Decrease Decimal feature in Excel. However, after adjusting, the actual value showing in the formula bar doesn’t change at all (See below screenshot). So how to round percentage values and let both actual value and displaying value with two decimal places? This article will introduce you some solutions.

Round up/down percentage values to two decimal places with formulas

Round up/down percentage values to two decimal places without formulas

Round percentage values to two decimal places with/without formulas

Easily combine multiple worksheets/workbooks/CSV files into one worksheet/workbook

It may be tedious to combine dozens of sheets from different workbooks into one sheet. But with Kutools for Excel’s Combine (worksheets and workbooks) utility, you can get it done with just several clicks! Full Feature Free Trial 30-day!
ad combine sheets books 1

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

Round up/down percentage values to two decimal places with formulas

We can apply ROUND function, ROUNDUP function, or ROUNDDOWN function to quickly round up/down percentage values to specified decimal places in Excel. Please do as follows:

Select a blank cell beside the percentage values, says Cell D2, type the formula =ROUND(C2,4) (C2 is the percentage value whose decimal places you will change) into it, and then drag this cell’s AutoFill Handle to the range as you need. See screenshot:

Notes:
(1) For rounding up percentage values to two decimal places, please apply this formula =ROUNDUP(C2,4);
(2) For rounding down percentage values to two decimal places, please apply this formula =ROUNDDOWN(C2,4);
(3) For rounding percentage values to N decimal places, please apply this formula =ROUND(C2, N+2). For example, you need to round to 1 decimal place, please change the formula to =ROUND(C2, 3).
(4) If rounding results are not in percentage format, please select the rounding results and click the Percentage button; if rounding results are not with specific decimal place, please select the rounding results, and click the  Increase Decimal button or  Decrease Decimal button. See screenshot:


Round up/down percentage values to two decimal places without formulas

If you have installed Kutools for Excel, you can apply its Round utility to easily round up/down percentage values to specified decimal places without formulas. Please do as follows:

1. Select the percentage values you will round, and click Kutools > Round.

2. In the opening Round without Formula dialog box, type 4 into the Decimal place box, select one option as you need in the Option section, and click the Ok button. See below screenshot:
And now all selected percentage values are rounded up/down/even to two decimal places.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Notes:
(1) For rounding percentage values to N decimal places, please enter N+2 into the Decimal place box. For example, for rounding to 1 decimal places, please enter 3 (=1+2) into the Decimal place box.
(2) If rounding results are not in percentage format, please select the rounding results and click the Percentage button; if rounding results are not with specific decimal place, please select the rounding results, and click the  Increase Decimal button or  Decrease Decimal button. See screenshot:


Round percentage values to two decimal places with/without formulas

In this section I will recommend Kutools for Excel’s Operation utility to round percentage values to specific decimal places with or without formulas, and overwrite original percentage values in Excel. Please do as follows:

1. Select the percentage values you will round, and click Kutools > More (in Editing group) > Operation. See screenshot:

2. In the Operation Tools dialog box, please click to highlight the Rounding in the Operation box, type 4 into the Operand section, and click the Ok button.

Notes:
(1) For rounding percentage values to N decimal places, please enter N+2 into the box in the Operand section. For example, for rounding to 1 decimal places, please enter 3 (=1+2).
(2) You can round the percentage values with or without formulas:

If uncheck the Create formulas option:

If check the Create formulas option:

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

(3) If rounding results are not in percentage format, please select the rounding results and click the Percentage button; if rounding results are not with specific decimal place, please select the rounding results, and click the  Increase Decimal button or  Decrease Decimal button. See screenshot:


Demo: round percentage values to two decimal places in Excel

Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Easily add percentage sign to numbers without multiplying 100 in Excel

Normally we add percentage sign to numbers by changing number formatting, and this method will show 6.1 as 610%. But Kutools for Excel’s Add Text utility can help you easily add mass percentage signs to multiple numbers without multiplying 100. Full Feature Free Trial 30-day!
ad add text percentage sign


Related articles:


Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.