{"id":4112,"date":"2018-11-06T11:47:48","date_gmt":"2018-11-06T16:47:48","guid":{"rendered":"http:\/\/lisa.rushworth.us\/?p=4112"},"modified":"2018-12-24T11:45:29","modified_gmt":"2018-12-24T16:45:29","slug":"did-you-know-excel-can-convert-between-units-of-measure","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=4112","title":{"rendered":"Did you know \u2026 Excel can convert between units of measure?"},"content":{"rendered":"\r\n<p>Spend enough time reading temperature probe data, and you get to where you just <em>know<\/em> 23 is room temperature, and 82 is going to cook the CPU. And sure you can type \u201c23 C in F\u201d into Google and get the Fahrenheit equivalent, but that\u2019s hardly efficient with a long list of values. You could look up the formula and have Excel perform the computation, too. But did you know Excel can convert between many units of measure <em>without<\/em> you finding the conversion formula?<\/p>\r\n\r\n\r\n\r\n<p>Excel\u2019s <a href=\"https:\/\/support.office.com\/en-us\/article\/convert-function-d785bef1-808e-4aac-bdcd-666c810f9af2\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Excel\u2019s CONVERT() function allows you to display values in whatever unit is mostfamiliar to you.  (opens in a new tab)\">CONVERT() function<\/a> allows you to display values in whatever unit is most familiar to you. Usage is convert(CellToConvert,OriginalUnits,DesiredUnits)<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"305\" class=\"wp-image-4113\" src=\"http:\/\/lisa.rushworth.us\/wp-content\/uploads\/2018\/12\/Excel-Convert01-1024x305.png\" alt=\"\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-Convert01-1024x305.png 1024w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-Convert01-300x89.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-Convert01-768x229.png 768w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-Convert01.png 1093w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>Voila \u2013 the values in your chosen unit.<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"820\" height=\"323\" class=\"wp-image-4114\" src=\"http:\/\/lisa.rushworth.us\/wp-content\/uploads\/2018\/12\/Excel-Convert02.png\" alt=\"\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-Convert02.png 820w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-Convert02-300x118.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/12\/Excel-Convert02-768x303.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/figure>\r\n<p>If you use the units of measure in column headers, you can use the header cells as the current and desired unit of measure values &#8212; remember to use the $ anchors, otherwise copying your formula will not yield the right answer!<\/p>\r\n<p><a href=\"http:\/\/lisa.rushworth.us\/?attachment_id=4176\" rel=\"attachment wp-att-4176\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-4176\" src=\"http:\/\/lisa.rushworth.us\/wp-content\/uploads\/2018\/11\/Excel-Convert05-1024x161.png\" alt=\"\" width=\"960\" height=\"151\" srcset=\"https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/11\/Excel-Convert05-1024x161.png 1024w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/11\/Excel-Convert05-300x47.png 300w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/11\/Excel-Convert05-768x121.png 768w, https:\/\/www.rushworth.us\/lisa\/wp-content\/uploads\/2018\/11\/Excel-Convert05.png 1176w\" sizes=\"auto, (max-width: 960px) 100vw, 960px\" \/><\/a><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>Spend enough time reading temperature probe data, and you get to where you just know 23 is room temperature, and 82 is going to cook the CPU. And sure you can type \u201c23 C in F\u201d into Google and get the Fahrenheit equivalent, but that\u2019s hardly efficient with a long list of values. You could &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[677],"tags":[709,691,265],"class_list":["post-4112","post","type-post","status-publish","format-standard","hentry","category-office-365","tag-microsoft-excel","tag-microsoft-office","tag-office-365"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4112"}],"version-history":[{"count":4,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4112\/revisions"}],"predecessor-version":[{"id":4178,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/4112\/revisions\/4178"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}