{"id":7470,"date":"2017-12-19T13:29:13","date_gmt":"2017-12-19T12:29:13","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=7470"},"modified":"2024-05-18T17:38:11","modified_gmt":"2024-05-18T15:38:11","slug":"10-1-ways-to-round-numbers-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/","title":{"rendered":"10 + 1 Ways to Round Numbers in Excel"},"content":{"rendered":"<p><strong>This is a guest post by Alan Murray from <a href=\"http:\/\/www.computergaga.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Computergaga<\/a>.<\/strong><\/p>\n<p>There are many ways in which you can round numbers in Excel. These techniques will typically involve formatting the values, or using <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formulas\" data-wpil-keyword-link=\"linked\">formulas<\/a>.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#This_post_on_How_to_round_numbers_in_Excel_will_look_at_10_round_functions_in_Excel_and_then_look_at_some_formatting_techniques\" title=\"This post on How to round numbers in Excel will look at 10 round functions in Excel, and then look at some formatting techniques.\">This post on How to round numbers in Excel will look at 10 round functions in Excel, and then look at some formatting techniques.<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#The_ROUND_Function\" title=\"The ROUND Function\">The ROUND Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#ROUNDUP_Function\" title=\"ROUNDUP Function\">ROUNDUP Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#ROUNDDOWN_Function\" title=\"ROUNDDOWN Function\">ROUNDDOWN Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#MROUND_Function\" title=\"MROUND Function\">MROUND Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#CEILING_Function\" title=\"CEILING Function\">CEILING Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#FLOOR_Function\" title=\"FLOOR Function\">FLOOR Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#INT_Function\" title=\"INT Function\">INT Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#TRUNC_Function\" title=\"TRUNC Function\">TRUNC Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#ODD_Function\" title=\"ODD Function\">ODD Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#EVEN_Function\" title=\"EVEN Function\">EVEN Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#Extra_Method_Use_the_Excel_Formatting_Options\" title=\"Extra Method: Use the Excel Formatting Options\">Extra Method: Use the Excel Formatting Options<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/10-1-ways-to-round-numbers-in-excel\/#About_the_Author\" title=\"About the Author\">About the Author<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"This_post_on_How_to_round_numbers_in_Excel_will_look_at_10_round_functions_in_Excel_and_then_look_at_some_formatting_techniques\"><\/span>This post on How to round numbers in Excel will look at 10 round functions in Excel, and then look at some formatting techniques.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>This blog includes the following 10 + 1 ways to round numbers in Excel:<\/p>\n<ul>\n<li><a href=\"#round-function\">ROUND Function<\/a><\/li>\n<li><a href=\"#roundup-function\">ROUNDUP Function<\/a><\/li>\n<li><a href=\"#rounddown-function\">ROUNDDOWN Function<\/a><\/li>\n<li><a href=\"#mround-function\">MROUND Function<\/a><\/li>\n<li><a href=\"#ceiling-function\">CEILING Function<\/a><\/li>\n<li><a href=\"#floor-function\">FLOOR Function<\/a><\/li>\n<li><a href=\"#int-function\">INT Function<\/a><\/li>\n<li><a href=\"#trunc-function\">TRUNC Function<\/a><\/li>\n<li><a href=\"#odd-function\">ODD Function<\/a><\/li>\n<li><a href=\"#even-function\">EVEN Function<\/a><\/li>\n<li><a href=\"#use-the-excel-formatting-options\">Use the Excel Formatting Options<\/a><\/li>\n<\/ul>\n\n<h2><span class=\"ez-toc-section\" id=\"The_ROUND_Function\"><\/span><strong><a id=\"round-function\"><\/a>The ROUND Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The <a href=\"https:\/\/youtu.be\/gp0cwnPFv3U\" target=\"_blank\" rel=\"noopener noreferrer\">ROUND function<\/a> in Excel will return a number rounded to a specified number of digits.<\/p>\n<p>You can round a number to the right or left of the decimal point. So whether you want to round to a specific number of decimals, or to the nearest hundredth, the ROUND function can help.<\/p>\n<p>The ROUND function looks like below;<\/p>\n<p><strong><em>=ROUND(<span style=\"color: #0000ff\">number<\/span>, <span style=\"color: #ff0000\">num_digits<\/span>)<\/em><\/strong><\/p>\n<p>The <span style=\"color: #0000ff\"><strong><em>number<\/em><\/strong><\/span> is the number that you want to round, and then <span style=\"color: #ff0000\"><strong><em>num_digits<\/em><\/strong><\/span> is how many digits you want to round the value to.<\/p>\n<p>You can enter a positive or negative value for <strong><span style=\"color: #ff0000\"><em>num_digits<\/em><\/span><\/strong> as shown in the examples below.<\/p>\n<p>A positive value rounds to the right of the decimal point, and a negative value rounds to the left of the decimal point (i.e. to the nearest 10, 100, 1000, etc). You can also enter 0 to simply round to the nearest integer.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/round.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone wp-image-7480 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/round.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"595\" height=\"311\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/round.png 595w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/round-300x157.png 300w\" sizes=\"(max-width: 595px) 100vw, 595px\" \/><\/a><\/p>\n<p>The ROUND function will round a number of 5-9 up, and a number of 1-4 down.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ROUNDUP_Function\"><\/span><strong><a id=\"roundup-function\"><\/a>ROUNDUP Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The ROUNDUP function returns a number rounded up to a specified number of places.<\/p>\n<p>It rounds all numbers from 1 to 9 up.<\/p>\n<p><strong><em>=ROUNDUP(<span style=\"color: #0000ff\">number<\/span>, <span style=\"color: #ff0000\">num_digits<\/span>)<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/roundup.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone wp-image-7482 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/roundup.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"630\" height=\"310\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/roundup.png 630w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/roundup-300x148.png 300w\" sizes=\"(max-width: 630px) 100vw, 630px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ROUNDDOWN_Function\"><\/span><strong><a id=\"rounddown-function\"><\/a>ROUNDDOWN Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The ROUNDDOWN function returns a number rounded down to a specified number of places.<\/p>\n<p>It rounds all digits from 1 to 9 down.<\/p>\n<p><strong><em>=ROUNDDOWN(<span style=\"color: #0000ff\">number<\/span>, <span style=\"color: #ff0000\">num_digits<\/span>)<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/rounddown.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7481\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/rounddown.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"675\" height=\"314\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/rounddown.png 675w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/rounddown-300x140.png 300w\" sizes=\"(max-width: 675px) 100vw, 675px\" \/><\/a><\/p>\n<p>Now that you have learned how to round numbers in Excel, let&#8217;s move to related function &#8211; MROUND.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"MROUND_Function\"><\/span><strong><a id=\"mround-function\"><\/a>MROUND Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The MROUND function returns a number rounded to a specified multiple.<\/p>\n<p>For example, this function can be used to;<\/p>\n<ul>\n<li>Round a price to the nearest 0.05<\/li>\n<li>Round a time to the nearest 30 minutes.<\/li>\n<\/ul>\n<p>The MROUND function requires the number you want to round, and the multiple to round it to.<\/p>\n<p><strong><em>=MROUND(<span style=\"color: #0000ff\">number<\/span>, <span style=\"color: #ff0000\">multiple<\/span>)<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/mround.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7478\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/mround.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"784\" height=\"291\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/mround.png 784w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/mround-300x111.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/mround-768x285.png 768w\" sizes=\"(max-width: 784px) 100vw, 784px\" \/><\/a><\/p>\n<p>Check out this video of the MROUND function being used to round a time to the nearest 15 minutes.<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/MlHcqJHs1ao \" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CEILING_Function\"><\/span><strong><a id=\"ceiling-function\"><\/a>CEILING Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The CEILING function will round a number up to the nearest multiple that you specify.<\/p>\n<p>It works like the MROUND function, but ensures that the number is always rounded up.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ceiling.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7471\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ceiling.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"766\" height=\"295\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ceiling.png 766w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/ceiling-300x116.png 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FLOOR_Function\"><\/span><strong><a id=\"floor-function\"><\/a>FLOOR Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The FLOOR function works like the CEILING function but ensures that a number is rounded down to the nearest multiple that you specify.<\/p>\n<p>For example, this function could be used to;<\/p>\n<ul>\n<li>Round a year down to the nearest decade<\/li>\n<li>Round a price down to the nearest 0.5.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/floor.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7474\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/floor.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"766\" height=\"295\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/floor.png 766w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/floor-300x116.png 300w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"INT_Function\"><\/span><strong><a id=\"#int-function\"><\/a>INT Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The INT function rounds a number down to the nearest integer. This function always rounds down, so a positive number gets smaller, and a negative number becomes more negative.<\/p>\n<p>The INT functions just requires the number to round.<\/p>\n<p><strong><em>=INT(<span style=\"color: #0000ff\">number<\/span>)<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/int.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7476\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/int.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"700\" height=\"290\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/int.png 700w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/int-300x124.png 300w\" sizes=\"(max-width: 700px) 100vw, 700px\" \/><\/a><\/p>\n<p>There are many interesting uses for the INT function such as to help calculate the days, hours and minutes elapsed between two dates (shown in the video below), or to help <a href=\"https:\/\/youtu.be\/KNClNRC2xpk\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">create a 5 star rating system<\/a>.<\/p>\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/OSKNu8I5Rx0\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"TRUNC_Function\"><\/span><strong><a id=\"#trunc-function\"><\/a>TRUNC Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The TRUNC function extracts the part of a number specified by a given number of digits. Technically this is not a rounding function, but I feel it deserves to be spoken about along with these other functions.<\/p>\n<p>To use the TRUNC function you need to provide the number to truncate, and the number of digits to truncate to.<\/p>\n<p><strong><em>=TRUNC(<span style=\"color: #0000ff\">number<\/span>,<span style=\"color: #ff0000\"> [num_digits]<\/span>)<\/em><\/strong><\/p>\n<p>Specifying the number of digits to truncate to is optional, and if not specified 0 is used.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/trunc.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7483\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/trunc.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"698\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/trunc.png 698w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/trunc-300x126.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/a><\/p>\n<p>The TRUNC function is commonly used to extract the integer part of a number, just like the INT function. However, they differ in the way that TRUNC will simply truncate the integer portion, whilst INT will round down to the nearest integer.<\/p>\n<p>To get only the decimal portion of the number you could do;<\/p>\n<p><strong><em>=A1-TRUNC(A1)<\/em><\/strong><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"ODD_Function\"><\/span><strong><a id=\"#odd-function\"><\/a>ODD Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The ODD function returns the next odd integer after rounding a number away from zero.<\/p>\n<p>Both positive and negative numbers are rounded away from zero, so positive numbers get bigger, and negative numbers become smaller.<\/p>\n<p>The ODD function just requires the number to round.<\/p>\n<p><strong><em>=ODD(<span style=\"color: #0000ff\">number<\/span>)<\/em><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/odd.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7479\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/odd.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"698\" height=\"290\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/odd.png 698w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/odd-300x125.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"EVEN_Function\"><\/span><strong><a id=\"#even-function\"><\/a>EVEN Function<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The EVEN function works in the same way as ODD, but returns the next even integer after rounding away from zero.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/even.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7473\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/even.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"698\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/even.png 698w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/even-300x126.png 300w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Extra_Method_Use_the_Excel_Formatting_Options\"><\/span><strong><a id=\"#use-the-excel-formatting-options\"><\/a>Extra Method: Use the Excel Formatting Options<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In this blog, you can also use how to round numbers in Excel without <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a>. By using the formatting options of Excel, you can change the presentation of the number, without actually changing the number.<\/p>\n<p>So you could hide the decimals, or present a value to the nearest thousand, but it will not affect the original number.<\/p>\n<p>The simplest way to show or hide the decimals in a range of cells is to use the <strong>Increase Decimal<\/strong> and <strong>Decrease Decimal<\/strong> buttons on the <strong>Home<\/strong> tab.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/decimal-buttons.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7472\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/decimal-buttons.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"280\" height=\"154\" \/><\/a><\/p>\n<p>When the decimals are hidden, Excel will round the values in the cell down for numbers 1-4, and up for numbers 5-9. This is just like the ROUND function, but does not change the value like ROUND.<\/p>\n<p>Using this technique, you will learn how to round numbers in Excel without formula.<\/p>\n<p>Let\u2019s look at another example. We can use the custom formatting options of Excel to display a number as thousands or millions.<\/p>\n<ol>\n<li>Open the Format Cells dialog by pressing <strong>Ctrl + 1<\/strong>.<\/li>\n<li>Ensure the <strong>Number<\/strong> tab is selected and then click <strong>Custom<\/strong>.<\/li>\n<li>In the <strong>Type<\/strong> field enter <em>0, \u201cK\u201d<\/em> to display as thousands or <em>0,, \u201cM\u201d<\/em> to display as millions.<\/li>\n<\/ol>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/format-as-millions.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone size-full wp-image-7475\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/format-as-millions.png\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"529\" height=\"465\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/format-as-millions.png 529w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/format-as-millions-300x264.png 300w\" sizes=\"(max-width: 529px) 100vw, 529px\" \/><\/a><\/p>\n<p>The decimal places buttons can be used to show more detail if desired.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel provides many ways on how to round numbers in Excel to a specific integer, or to a number of decimal places So whatever your requirements, Excel has a way.<\/p>\n<p>The various <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-two-decimal-places\/\" target=\"_blank\" rel=\"noopener\">rounding functions of Excel<\/a> can be used to change and present the value in the best way possible. Be sure to understand the difference and choose the right one to prevent unexpected results.<\/p>\n<p>Sometimes you may not want to affect the number, so the custom formatting feature of Excel is your ally in these moments.<\/p>\n<p><span style=\"color: #000000\"><strong>Further Learning:<\/strong><\/span><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/round-off-numbers-with-excels-round-formula\/\" target=\"_blank\" rel=\"noopener\">Round Off Numbers with ROUND Formula<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/descriptive-statistics-in-excel\/\" target=\"_blank\" rel=\"noopener\">A Comprehensive Guide to Descriptive Statistics in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/countif-with-or-logic-in-excel\/\" target=\"_blank\" rel=\"noopener\">3 Simple Methods to Explore the Power of COUNTIF with OR Logic in Excel<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"About_the_Author\"><\/span><strong>About the Author<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"http:\/\/www.computergaga.com\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"10 + 1 Ways to Round Numbers in Excel\" class=\"alignnone wp-image-7477 size-thumbnail\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/12\/me-150x150.jpg\" alt=\"10 + 1 Ways to Round Numbers in Excel\" width=\"150\" height=\"150\" \/><\/a><\/p>\n<p>Alan is the founder of <a href=\"http:\/\/www.computergaga.com\" target=\"_blank\" rel=\"noopener noreferrer\">Computergaga<\/a>. When he is not training people in Excel he can normally be found running, or spending time with his wife and two children.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a guest post by Alan Murray from Computergaga. There are many ways in which you can round numbers in Excel. These techniques will typically involve formatting the values, or using formulas. This post on How to round numbers in Excel will look at 10 round functions in Excel, and then look at some [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":7486,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"10 + 1 Ways to Round Numbers in Excel","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,15,289],"tags":[142,112,238],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7470"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=7470"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/7470\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/7486"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=7470"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=7470"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=7470"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}