{"id":486999,"date":"2022-08-22T20:00:41","date_gmt":"2022-08-22T17:00:41","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-convert-almost-any-unit-in-microsoft-excel\/"},"modified":"2022-08-22T20:00:41","modified_gmt":"2022-08-22T17:00:41","slug":"how-to-convert-almost-any-unit-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/","title":{"rendered":"#How to Convert Almost Any Unit in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3dfc6780d04\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3dfc6780d04\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#%E2%80%9CHow_to_Convert_Almost_Any_Unit_in_Microsoft_Excel%E2%80%9D\" >&#8220;How to Convert Almost Any Unit in Microsoft Excel&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Which_Units_Can_You_Convert\" >Which Units Can You Convert?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Use_the_CONVERT_Function\" >Use the CONVERT Function<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Distance\" >Distance<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Temperature\" >Temperature<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Volume\" >Volume<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Area\" >Area<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Speed\" >Speed<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Information\" >Information<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-convert-almost-any-unit-in-microsoft-excel\/#Help_With_Unit_Abbreviations\" >Help With Unit Abbreviations<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Convert_Almost_Any_Unit_in_Microsoft_Excel%E2%80%9D\"><\/span>&#8220;How to Convert Almost Any Unit in Microsoft Excel&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-757715\" data-pagespeed-no-defer=\"\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo on a green background\" width=\"1200\" height=\"675\"\/><\/p>\n<p>Unit conversions are commonplace. Whether you need feet to meters, Fahrenheit to Celsius, or teaspoons to tablespoons, you can take advantage of the CONVERT function in Microsoft Excel for a dozen types of conversion.<\/p>\n<p>The nice thing about this function in Excel is that it uses a basic formula with only a few arguments. So not only is it simple to use, but it\u2019s also easy to remember.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Which_Units_Can_You_Convert\"><\/span>Which Units Can You Convert?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>As mentioned, you can convert more than 12 types of units with the function.<\/p>\n<ul>\n<li>Weight and mass<\/li>\n<li>Distance<\/li>\n<li>Time<\/li>\n<li>Pressure<\/li>\n<li>Force<\/li>\n<li>Energy<\/li>\n<li>Power<\/li>\n<li>Magnetism<\/li>\n<li>Temperature<\/li>\n<li>Volume<\/li>\n<li>Area<\/li>\n<li>Information<\/li>\n<li>Speed<\/li>\n<\/ul>\n<p>Let\u2019s look at some examples.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_CONVERT_Function\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Use the CONVERT Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The syntax for the function is <code>CONVERT(reference, from_unit, to_unit)<\/code> where you\u2019ll need all three arguments. The <code>reference<\/code> argument can be a number or a cell reference.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Distance\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">Distance<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For a simple distance conversion, we\u2019ll convert the inches in cell A2 to feet using this formula:<\/p>\n<pre>=CONVERT(A2,\"in\",\"ft\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819222\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/InchesFeetCell-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert inches to feet\" width=\"515\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also use a number as the reference and create the formula this way:<\/p>\n<pre>=CONVERT(24,\"in\",\"ft\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819223\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/InchesFeet-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert inches to feet using a number\" width=\"515\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Here are a few other abbreviations for common distance measurements:<\/p>\n<ul>\n<li>Yard: yd<\/li>\n<li>Meter: m<\/li>\n<li>Statute mile: mi<\/li>\n<li>Nautical mile: Nmi<\/li>\n<li>U.S. survey mile: survey_mi<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Temperature\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_3\">Temperature<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Converting temperatures is common when you\u2019re working with someone who uses Celsius instead of Fahrenheit.<\/p>\n<p>Here, we\u2019ll convert the temperature in cell A2 from Fahrenheit to Celsius:<\/p>\n<pre>=CONVERT(A2,\"fah\",\"cel\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819224\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/FahrenheitCelsiusCell-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert Fahrenheit to Celsius\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Note, you can also use \u201cF\u201d instead of \u201cfah\u201d and \u201cC\u201d instead of \u201ccel.\u201d Plus, you can use a number instead of a cell reference.<\/p>\n<p>You can use this formula to convert 78 from Fahrenheit to Celsius:<\/p>\n<pre>=CONVERT(78,\"F\",\"C\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819225\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/FahrenheitCelsius-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert Fahrenheit to Celsius using a number\" width=\"500\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Other temperature abbreviations include:<\/p>\n<ul>\n<li>Kelvin: K or kel<\/li>\n<li>Degrees Rankine: Rank<\/li>\n<li>Degrees Reaumur: Reau<\/li>\n<\/ul>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> It\u2019s likely that when using CONVERT with temperature and other units, it\u2019s likely you\u2019ll want to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/356645\/how-to-round-off-decimal-values-in-excel\/\">round decimal values.<\/p><\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Volume\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_4\">Volume<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you spend time in the kitchen, then you might find yourself converting those types of measurements. You can convert teaspoons to tablespoons for the value in cell A2:<\/p>\n<pre>=CONVERT(A2,\"tsp\",\"tbs\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819226\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/TeaspoonTablespoon-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert teaspoons to tablespoons\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>With this formula, you can convert a specific number U.S pints to U.K. pints:<\/p>\n<pre>=CONVERT(20,\"us_pt\",\"uk_pt\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819227\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/USUKPints-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert US to UK pints\" width=\"590\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Here are a handful of additional volume abbreviations you might use:<\/p>\n<ul>\n<li>Ounce: oz<\/li>\n<li>Cup: cup<\/li>\n<li>Quart: qt<\/li>\n<li>Gallon: gal<\/li>\n<li>Liter: l, L, or lt<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Area\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_5\">Area<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Need to perform some area conversions? This formula converts the value in cell A2 from square feet to square inches:<\/p>\n<pre>=CONVERT(A2,\"ft2\",\"in2\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819229\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/SquareFeetInches-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert square feet to square inches\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And with this formula, you can convert square meters to square miles:<\/p>\n<pre>=CONVERT(A2,\"m2\",\"mi2\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819230\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/SquareMetersMiles-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert square meters to square miles\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Additional area abbreviations you might need include:<\/p>\n<ul>\n<li>Square yards: yd2 or yd^2<\/li>\n<li>Square nautical miles: Nmi2 or Nmi^2<\/li>\n<li>Morgen: Morgen<\/li>\n<li>International acre: uk_acre<\/li>\n<li>U.S. statute acre: us_acre<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Speed\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_6\">Speed<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>How about a speed conversion? Here, you can convert the value in cell A2 from meters per hour to meters per second:<\/p>\n<pre>=CONVERT(A2,\"m\/h\",\"m\/s\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819232\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/MetersHoursSeconds-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert meters per hour to meters per second\" width=\"550\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can also convert from meters per hour to miles per hour:<\/p>\n<pre>=CONVERT(65,\"m\/h\",\"mph\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819233\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/MetersMiles-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert meters per hour to miles per hour\" width=\"550\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Information\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_7\">Information<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>For one more example, we\u2019ll convert our A2 value from bits to bytes with this formula:<\/p>\n<pre>=CONVERT(A2,\"bit\",\"byte\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819234\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/BitByte-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert bits to bytes\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Help_With_Unit_Abbreviations\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_8\">Help With Unit Abbreviations<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The most difficult part of using the CONVERT function in Excel is knowing the abbreviations for the units. You can take a look at <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/support.microsoft.com\/en-us\/office\/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2\">Microsoft\u2019s Support page for the function<\/a> if you want to convert a unit that isn\u2019t as common as some others. However, Excel does offer help too.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Find the Function You Need in Microsoft Excel<\/em><\/strong><\/p>\n<p>When you enter the CONVERT function into your sheet\u2019s Formula Bar, you can select a unit argument to see the options and pick the one you need.<\/p>\n<p>Here, we\u2019re converting ounces to cups. You can see when we place our cursor in the argument\u2019s spot for the <code>to_unit<\/code>, a drop-down list appears. Double-click the unit you want and the abbreviation will appear in the formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819235\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/UnitDropdown-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Dropdown to select a unit for the formula\" width=\"650\" height=\"226\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, insert your closing parenthesis and press Enter or Return to apply the formula and receive the result.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-819236\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/07\/OuncesCups-ExcelConvertFunction.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Formula to convert ounces to cups\" width=\"540\" height=\"150\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can use this drop-down box to choose both the <code>from_unit<\/code> and <code>to_unit<\/code> arguments easily. This is handy for those abbreviations that are less than obvious.<\/p>\n<p>When you have an Excel spreadsheet that uses units of measurement like these, remember the CONVERT function.<\/p>\n<p>For more, take a look at how to convert text to dates or how to convert text to numbers in Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/819208\/how-to-convert-almost-any-unit-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Convert Almost Any Unit in Microsoft Excel&#8221; Unit conversions are commonplace. Whether you need feet to meters, Fahrenheit to Celsius, or teaspoons to tablespoons, you can take advantage of the CONVERT function in Microsoft Excel for a dozen types of conversion. The nice thing about this function in Excel is that it uses&#8230;<\/p>\n","protected":false},"author":1,"featured_media":487000,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/microsoft_excel_hero_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-486999","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/486999","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=486999"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/486999\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/487000"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=486999"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=486999"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=486999"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}