{"id":10018,"date":"2019-11-20T15:36:10","date_gmt":"2019-11-20T14:36:10","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=10018"},"modified":"2024-03-27T23:02:37","modified_gmt":"2024-03-27T22:02:37","slug":"convert-formula-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-formula-in-excel\/","title":{"rendered":"CONVERT Formula in Excel"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p><em><strong>What does it do?<\/strong><\/em><\/p>\n<p>Converts a number from one measurement system to another<\/p>\n<p><em><strong>Formula breakdown:<\/strong><\/em><\/p>\n<p>=CONVERT(<span style=\"color: #0000ff\">number<\/span>, <span style=\"color: #ff6600\">from_unit<\/span>, <span style=\"color: #339966\">to_unit<\/span>)<\/p>\n<p><em><strong>What it means:<\/strong><\/em><\/p>\n<p>=CONVERT(<span style=\"color: #0000ff\">number<\/span>, <span style=\"color: #ff6600\">starting measurement system<\/span>, <span style=\"color: #339966\">target measurement system<\/span>)<\/p>\n<hr \/>\n<p>Did you know that Excel can convert numbers from one measurement system to another measurement system? Yes you can with the\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/square-mm-to-square-m\/\" target=\"_blank\" rel=\"noopener\">CONVERT Formula!<\/a><\/strong> You will be surprised at what units it can convert for you!<\/p>\n<p>I explain how you can do this below:<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/xre4kJV1B2s?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">CONVERT-FORMULA.xlsx<\/span><\/a><\/p>\n<p class=\"line-two\">\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> We need to <strong>enter the <i>CONVERT\u00a0<\/i>function in a blank cell<\/strong>:<\/p>\n<h2 style=\"text-align: center\"><span style=\"color: #0000ff\">=CONVERT(<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONVERT Formula in Excel\" class=\"aligncenter size-full wp-image-10449\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-01.jpg\" alt=\"CONVERT Formula in Excel\" width=\"906\" height=\"178\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-01.jpg 906w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-01-300x59.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-01-768x151.jpg 768w\" sizes=\"(max-width: 906px) 100vw, 906px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span>\u00a0The <b>CONVERT\u00a0<\/b>arguments:<\/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><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/convert-formula-in-excel\/#number\" title=\"number\">number<\/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\/convert-formula-in-excel\/#from_unit\" title=\"from_unit\">from_unit<\/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\/convert-formula-in-excel\/#to_unit\" title=\"to_unit\">to_unit<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"number\"><\/span><span style=\"color: #0000ff\"><em><strong>number<\/strong><\/em><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>What is the numeric measurement?<\/strong><\/p>\n<p><em>Select the cell containing the number that you want to convert<\/em><\/p>\n<h2 style=\"text-align: center\">=CONVERT(<span style=\"color: #0000ff\">C9,<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONVERT Formula in Excel\" class=\"aligncenter size-full wp-image-10450\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-02.jpg\" alt=\"CONVERT Formula in Excel\" width=\"909\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-02.jpg 909w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-02-300x59.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-02-768x152.jpg 768w\" sizes=\"(max-width: 909px) 100vw, 909px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"from_unit\"><\/span><span style=\"color: #0000ff\"><em><strong>from_unit<\/strong><\/em><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>What is the starting measurement system?<\/strong><\/p>\n<p><em>Select the cell containing the starting measurement system.<\/em><\/p>\n<h2 style=\"text-align: center\">=CONVERT(C9, <span style=\"color: #0000ff\">D9,<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONVERT Formula in Excel\" class=\"aligncenter size-full wp-image-10451\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-03.jpg\" alt=\"CONVERT Formula in Excel\" width=\"904\" height=\"184\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-03.jpg 904w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-03-300x61.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-03-768x156.jpg 768w\" sizes=\"(max-width: 904px) 100vw, 904px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"to_unit\"><\/span><span style=\"color: #0000ff\"><em><strong>to_unit<\/strong><\/em><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>What is the target measurement system?<\/strong><\/p>\n<p><em>Select the cell containing the target measurement system.<\/em><\/p>\n<h2 style=\"text-align: center\">=CONVERT(C9, D9,<span style=\"color: #0000ff\"> E9)<\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONVERT Formula in Excel\" class=\"aligncenter size-full wp-image-10453\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-04.jpg\" alt=\"CONVERT Formula in Excel\" width=\"879\" height=\"180\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-04.jpg 879w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-04-300x61.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-04-768x157.jpg 768w\" sizes=\"(max-width: 879px) 100vw, 879px\" \/><\/p>\n<p>Apply the same formula to the rest of the cells by dragging the lower right corner downwards.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONVERT Formula in Excel\" class=\"aligncenter size-full wp-image-10454\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-05.jpg\" alt=\"CONVERT Formula in Excel\" width=\"803\" height=\"191\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-05.jpg 803w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-05-300x71.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-05-768x183.jpg 768w\" sizes=\"(max-width: 803px) 100vw, 803px\" \/><\/p>\n<p>You now have your conversions completed!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" title=\"CONVERT Formula in Excel\" class=\"aligncenter size-full wp-image-10455\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-06.jpg\" alt=\"CONVERT Formula in Excel\" width=\"817\" height=\"213\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-06.jpg 817w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-06-300x78.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/11\/CONVERT-FORMULA-06-768x200.jpg 768w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Here is an extensive list of all of the units that you can use:<\/p>\n<table width=\"780\">\n<tbody>\n<tr>\n<td width=\"241\"><strong>Category<\/strong><\/td>\n<td width=\"189\"><strong>Unit<\/strong><\/td>\n<td width=\"350\"><strong>Usage in CONVERT FORMULA<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Gram<\/td>\n<td style=\"font-weight: 400\">&#8220;g&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Slug<\/td>\n<td style=\"font-weight: 400\">&#8220;sg&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Pound mass (avoirdupois)<\/td>\n<td style=\"font-weight: 400\">&#8220;lbm&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">U (atomic mass unit)<\/td>\n<td style=\"font-weight: 400\">&#8220;u&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Ounce mass (avoirdupois)<\/td>\n<td style=\"font-weight: 400\">&#8220;ozm&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Grain<\/td>\n<td style=\"font-weight: 400\">&#8220;grain&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">U.S. (short) hundredweight<\/td>\n<td style=\"font-weight: 400\">&#8220;cwt&#8221; or &#8220;shweight&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Imperial hundredweight<\/td>\n<td style=\"font-weight: 400\">&#8220;uk_cwt&#8221; or &#8220;lcwt&#8221; (&#8220;hweight&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Stone<\/td>\n<td style=\"font-weight: 400\">&#8220;stone&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Ton<\/td>\n<td style=\"font-weight: 400\">&#8220;ton&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Weight and mass<\/td>\n<td style=\"font-weight: 400\">Imperial ton<\/td>\n<td style=\"font-weight: 400\">&#8220;uk_ton&#8221; or &#8220;LTON&#8221; (&#8220;brton&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Meter<\/td>\n<td style=\"font-weight: 400\">&#8220;m&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Statute mile<\/td>\n<td style=\"font-weight: 400\">&#8220;mi&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Nautical mile<\/td>\n<td style=\"font-weight: 400\">&#8220;Nmi&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Inch<\/td>\n<td style=\"font-weight: 400\">&#8220;in&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Foot<\/td>\n<td style=\"font-weight: 400\">&#8220;ft&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Yard<\/td>\n<td style=\"font-weight: 400\">&#8220;yd&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Angstrom<\/td>\n<td style=\"font-weight: 400\">&#8220;ang&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Ell<\/td>\n<td style=\"font-weight: 400\">&#8220;ell&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Light-year<\/td>\n<td style=\"font-weight: 400\">&#8220;ly&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Parsec<\/td>\n<td style=\"font-weight: 400\">&#8220;parsec&#8221; or &#8220;pc&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Pica (1\/72 inch)<\/td>\n<td style=\"font-weight: 400\">&#8220;Picapt&#8221; or &#8220;Pica&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">Pica (1\/6 inch)<\/td>\n<td style=\"font-weight: 400\">&#8220;pica&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Distance<\/td>\n<td style=\"font-weight: 400\">U.S survey mile (statute mile)<\/td>\n<td style=\"font-weight: 400\">&#8220;survey_mi&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Time<\/td>\n<td style=\"font-weight: 400\">Year<\/td>\n<td style=\"font-weight: 400\">&#8220;yr&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Time<\/td>\n<td style=\"font-weight: 400\">Day<\/td>\n<td style=\"font-weight: 400\">&#8220;day&#8221; or &#8220;d&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Time<\/td>\n<td style=\"font-weight: 400\">Hour<\/td>\n<td style=\"font-weight: 400\">&#8220;hr&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Time<\/td>\n<td style=\"font-weight: 400\">Minute<\/td>\n<td style=\"font-weight: 400\">&#8220;mn&#8221; or &#8220;min&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Time<\/td>\n<td style=\"font-weight: 400\">Second<\/td>\n<td style=\"font-weight: 400\">&#8220;sec&#8221; or &#8220;s&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Pressure<\/td>\n<td style=\"font-weight: 400\">Pascal<\/td>\n<td style=\"font-weight: 400\">&#8220;Pa&#8221; (or &#8220;p&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Pressure<\/td>\n<td style=\"font-weight: 400\">Atmosphere<\/td>\n<td style=\"font-weight: 400\">&#8220;atm&#8221; (or &#8220;at&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Pressure<\/td>\n<td style=\"font-weight: 400\">mm of Mercury<\/td>\n<td style=\"font-weight: 400\">&#8220;mmHg&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Pressure<\/td>\n<td style=\"font-weight: 400\">PSI<\/td>\n<td style=\"font-weight: 400\">&#8220;psi&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Pressure<\/td>\n<td style=\"font-weight: 400\">Torr<\/td>\n<td style=\"font-weight: 400\">&#8220;Torr&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Force<\/td>\n<td style=\"font-weight: 400\">Newton<\/td>\n<td style=\"font-weight: 400\">&#8220;N&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Force<\/td>\n<td style=\"font-weight: 400\">Dyne<\/td>\n<td style=\"font-weight: 400\">&#8220;dyn&#8221; (or &#8220;dy&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Force<\/td>\n<td style=\"font-weight: 400\">Pound force<\/td>\n<td style=\"font-weight: 400\">&#8220;lbf&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Force<\/td>\n<td style=\"font-weight: 400\">Pond<\/td>\n<td style=\"font-weight: 400\">&#8220;pond&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">Joule<\/td>\n<td style=\"font-weight: 400\">&#8220;J&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">Erg<\/td>\n<td style=\"font-weight: 400\">&#8220;e&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">Thermodynamic calorie<\/td>\n<td style=\"font-weight: 400\">&#8220;c&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">IT calorie<\/td>\n<td style=\"font-weight: 400\">&#8220;cal&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">Electron volt<\/td>\n<td style=\"font-weight: 400\">&#8220;eV&#8221; (or &#8220;ev&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">Horsepower-hour<\/td>\n<td style=\"font-weight: 400\">&#8220;HPh&#8221; (or &#8220;hh&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">Watt-hour<\/td>\n<td style=\"font-weight: 400\">&#8220;Wh&#8221; (or &#8220;wh&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">Foot-pound<\/td>\n<td style=\"font-weight: 400\">&#8220;flb&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Energy<\/td>\n<td style=\"font-weight: 400\">BTU<\/td>\n<td style=\"font-weight: 400\">&#8220;BTU&#8221; (or &#8220;btu&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Power<\/td>\n<td style=\"font-weight: 400\">Horsepower<\/td>\n<td style=\"font-weight: 400\">&#8220;HP&#8221; (or &#8220;h&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Power<\/td>\n<td style=\"font-weight: 400\">Pferdest\u00e4rke<\/td>\n<td style=\"font-weight: 400\">&#8220;PS&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Power<\/td>\n<td style=\"font-weight: 400\">Watt<\/td>\n<td style=\"font-weight: 400\">&#8220;W&#8221; (or &#8220;w&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Magnetism<\/td>\n<td style=\"font-weight: 400\">Tesla<\/td>\n<td style=\"font-weight: 400\">&#8220;T&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Magnetism<\/td>\n<td style=\"font-weight: 400\">Gauss<\/td>\n<td style=\"font-weight: 400\">&#8220;ga&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Temperature<\/td>\n<td style=\"font-weight: 400\">Degree Celsius<\/td>\n<td style=\"font-weight: 400\">&#8220;C&#8221; (or &#8220;cel&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Temperature<\/td>\n<td style=\"font-weight: 400\">Degree Fahrenheit<\/td>\n<td style=\"font-weight: 400\">&#8220;F&#8221; (or &#8220;fah&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Temperature<\/td>\n<td style=\"font-weight: 400\">Kelvin<\/td>\n<td style=\"font-weight: 400\">&#8220;K&#8221; (or &#8220;kel&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Temperature<\/td>\n<td style=\"font-weight: 400\">Degrees Rankine<\/td>\n<td style=\"font-weight: 400\">&#8220;Rank&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Temperature<\/td>\n<td style=\"font-weight: 400\">Degrees R\u00e9aumur<\/td>\n<td style=\"font-weight: 400\">&#8220;Reau&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Teaspoon<\/td>\n<td style=\"font-weight: 400\">&#8220;tsp&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Modern teaspoon<\/td>\n<td style=\"font-weight: 400\">&#8220;tspm&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Tablespoon<\/td>\n<td style=\"font-weight: 400\">&#8220;tbs&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Fluid ounce<\/td>\n<td style=\"font-weight: 400\">&#8220;oz&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cup<\/td>\n<td style=\"font-weight: 400\">&#8220;cup&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">U.S. pint<\/td>\n<td style=\"font-weight: 400\">&#8220;pt&#8221; (or &#8220;us_pt&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">U.K. pint<\/td>\n<td style=\"font-weight: 400\">&#8220;uk_pt&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Quart<\/td>\n<td style=\"font-weight: 400\">&#8220;qt&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Imperial quart (U.K.)<\/td>\n<td style=\"font-weight: 400\">&#8220;uk_qt&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Gallon<\/td>\n<td style=\"font-weight: 400\">&#8220;gal&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Imperial gallon (U.K.)<\/td>\n<td style=\"font-weight: 400\">&#8220;uk_gal&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Liter<\/td>\n<td style=\"font-weight: 400\">&#8220;l&#8221; or &#8220;L&#8221; (&#8220;lt&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic angstrom<\/td>\n<td style=\"font-weight: 400\">&#8220;ang3&#8221; or &#8220;ang^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">U.S. oil barrel<\/td>\n<td style=\"font-weight: 400\">&#8220;barrel&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">U.S. bushel<\/td>\n<td style=\"font-weight: 400\">&#8220;bushel&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic feet<\/td>\n<td style=\"font-weight: 400\">&#8220;ft3&#8221; or &#8220;ft^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic inch<\/td>\n<td style=\"font-weight: 400\">&#8220;in3&#8221; or &#8220;in^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic light-year<\/td>\n<td style=\"font-weight: 400\">&#8220;ly3&#8221; or &#8220;ly^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic meter<\/td>\n<td style=\"font-weight: 400\">&#8220;m3&#8221; or &#8220;m^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic Mile<\/td>\n<td style=\"font-weight: 400\">&#8220;mi3&#8221; or &#8220;mi^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic yard<\/td>\n<td style=\"font-weight: 400\">&#8220;yd3&#8221; or &#8220;yd^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic nautical mile<\/td>\n<td style=\"font-weight: 400\">&#8220;Nmi3&#8221; or &#8220;Nmi^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Cubic Pica<\/td>\n<td style=\"font-weight: 400\">&#8220;Picapt3&#8221;, &#8220;Picapt^3&#8221;, &#8220;Pica3&#8221; or &#8220;Pica^3&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Gross Registered Ton<\/td>\n<td style=\"font-weight: 400\">&#8220;GRT&#8221; (&#8220;regton&#8221;)<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Volume<\/td>\n<td style=\"font-weight: 400\">Measurement ton (freight ton)<\/td>\n<td style=\"font-weight: 400\">&#8220;MTON&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">International acre<\/td>\n<td style=\"font-weight: 400\">&#8220;uk_acre&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">U.S. survey\/statute acre<\/td>\n<td style=\"font-weight: 400\">&#8220;us_acre&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square angstrom<\/td>\n<td style=\"font-weight: 400\">&#8220;ang2&#8243; or \u201cang^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Are<\/td>\n<td style=\"font-weight: 400\">&#8220;ar&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square feet<\/td>\n<td style=\"font-weight: 400\">&#8220;ft2&#8221; or &#8220;ft^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Hectare<\/td>\n<td style=\"font-weight: 400\">&#8220;ha&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square inches<\/td>\n<td style=\"font-weight: 400\">&#8220;in2&#8221; or &#8220;in^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square light-year<\/td>\n<td style=\"font-weight: 400\">&#8220;ly2&#8221; or &#8220;ly^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square meters<\/td>\n<td style=\"font-weight: 400\">&#8220;m2&#8221; or &#8220;m^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Morgen<\/td>\n<td style=\"font-weight: 400\">&#8220;Morgen&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square miles<\/td>\n<td style=\"font-weight: 400\">&#8220;mi2&#8221; or &#8220;mi^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square nautical miles<\/td>\n<td style=\"font-weight: 400\">&#8220;Nmi2&#8221; or &#8220;Nmi^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square Pica<\/td>\n<td style=\"font-weight: 400\">&#8220;Picapt2&#8221;, &#8220;Pica2&#8221;, &#8220;Pica^2&#8221; or &#8220;Picapt^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Area<\/td>\n<td style=\"font-weight: 400\">Square yards<\/td>\n<td style=\"font-weight: 400\">&#8220;yd2&#8221; or &#8220;yd^2&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Information<\/td>\n<td style=\"font-weight: 400\">Bit<\/td>\n<td style=\"font-weight: 400\">&#8220;bit&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Information<\/td>\n<td style=\"font-weight: 400\">Byte<\/td>\n<td style=\"font-weight: 400\">&#8220;byte&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Speed<\/td>\n<td style=\"font-weight: 400\">Admiralty knot<\/td>\n<td style=\"font-weight: 400\">&#8220;admkn&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Speed<\/td>\n<td style=\"font-weight: 400\">Knot<\/td>\n<td style=\"font-weight: 400\">&#8220;kn&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Speed<\/td>\n<td style=\"font-weight: 400\">Meters per hour<\/td>\n<td style=\"font-weight: 400\">&#8220;m\/h&#8221; or &#8220;m\/hr&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Speed<\/td>\n<td style=\"font-weight: 400\">Meters per second<\/td>\n<td style=\"font-weight: 400\">&#8220;m\/s&#8221; or &#8220;m\/sec&#8221;<\/td>\n<\/tr>\n<tr>\n<td style=\"font-weight: 400\">Speed<\/td>\n<td style=\"font-weight: 400\">Miles per hour<\/td>\n<td style=\"font-weight: 400\">&#8220;mph&#8221;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p class=\"\">The following abbreviated unit prefixes can be added in front of any <strong>metric<\/strong> from_unit or to_unit.<\/p>\n<table width=\"592\">\n<tbody>\n<tr>\n<td width=\"157\"><strong>Prefix<\/strong><\/td>\n<td width=\"243\"><strong>Multiplier<\/strong><\/td>\n<td width=\"192\"><strong>Abbreviation<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"157\">yotta<\/td>\n<td width=\"243\">1.00E+24<\/td>\n<td width=\"192\">&#8220;Y&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">zetta<\/td>\n<td width=\"243\">1.00E+21<\/td>\n<td width=\"192\">&#8220;Z&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">exa<\/td>\n<td width=\"243\">1.00E+18<\/td>\n<td width=\"192\">&#8220;E&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">peta<\/td>\n<td width=\"243\">1.00E+15<\/td>\n<td width=\"192\">&#8220;P&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">tera<\/td>\n<td width=\"243\">1.00E+12<\/td>\n<td width=\"192\">&#8220;T&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">giga<\/td>\n<td width=\"243\">1.00E+09<\/td>\n<td width=\"192\">&#8220;G&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">mega<\/td>\n<td width=\"243\">1.00E+06<\/td>\n<td width=\"192\">&#8220;M&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">kilo<\/td>\n<td width=\"243\">1.00E+03<\/td>\n<td width=\"192\">&#8220;k&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">hecto<\/td>\n<td width=\"243\">1.00E+02<\/td>\n<td width=\"192\">&#8220;h&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">dekao<\/td>\n<td width=\"243\">1.00E+01<\/td>\n<td width=\"192\">&#8220;da&#8221; or &#8220;e&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">deci<\/td>\n<td width=\"243\">1.00E-01<\/td>\n<td width=\"192\">&#8220;d&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">centi<\/td>\n<td width=\"243\">1.00E-02<\/td>\n<td width=\"192\">&#8220;c&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">milli<\/td>\n<td width=\"243\">1.00E-03<\/td>\n<td width=\"192\">&#8220;m&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">micro<\/td>\n<td width=\"243\">1.00E-06<\/td>\n<td width=\"192\">&#8220;u&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">nano<\/td>\n<td width=\"243\">1.00E-09<\/td>\n<td width=\"192\">&#8220;n&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">pico<\/td>\n<td width=\"243\">1.00E-12<\/td>\n<td width=\"192\">&#8220;p&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">femto<\/td>\n<td width=\"243\">1.00E-15<\/td>\n<td width=\"192\">&#8220;f&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">atto<\/td>\n<td width=\"243\">1.00E-18<\/td>\n<td width=\"192\">&#8220;a&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">zepto<\/td>\n<td width=\"243\">1.00E-21<\/td>\n<td width=\"192\">&#8220;z&#8221;<\/td>\n<\/tr>\n<tr>\n<td width=\"157\">yocto<\/td>\n<td width=\"243\">1.00E-24<\/td>\n<td width=\"192\">&#8220;y&#8221;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>How to Use the CONVERT Formula in Excel<\/strong><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/ebooks.myexcelonline.com\/products\/101-most-popular-excel-formulas-e-book\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-10741\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book.png\" alt=\"\" width=\"1200\" height=\"628\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book.png 1200w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-300x157.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-1024x536.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2018\/12\/MyExcelOnline.com-Formulas-E-Book-768x402.png 768w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; What does it do? Converts a number from one measurement system to another Formula breakdown: =CONVERT(number, from_unit, to_unit) What it means: =CONVERT(number, starting measurement system, target measurement system) Did you know that Excel can convert numbers from one measurement system to another measurement system? Yes you can with the\u00a0CONVERT Formula! You will be surprised [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17929,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[16,3],"tags":[219,550,142],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/10018"}],"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=10018"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/10018\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17929"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=10018"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=10018"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=10018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}