{"id":226,"date":"2014-09-26T23:15:54","date_gmt":"2014-09-27T05:15:54","guid":{"rendered":"http:\/\/www.schwie.com\/brad\/?p=226"},"modified":"2017-09-07T17:37:46","modified_gmt":"2017-09-07T23:37:46","slug":"excel-and-unicode","status":"publish","type":"post","link":"https:\/\/www.schwie.com\/brad\/?p=226","title":{"rendered":"Excel and Unicode"},"content":{"rendered":"<p>Most of my posts seem to be nerdy and this is more of the same, but if you&#8217;re into vapor intrusion and wanting to properly present results in Excel, you might find this helpful.<\/p>\n<p>While presenting VOC concentrations in micrograms per cubic meter in Excel, I noticed the greek-letter mu was being used instead of the proper &#8220;micro&#8221; SI prefix symbol. Yup, go ahead and snicker, there are <a href=\"http:\/\/en.wikipedia.org\/wiki\/Micro-\">subtle differences between the two<\/a>.<\/p>\n<p>If you&#8217;re on a Mac, the following shortcut defaults to the &#8220;micro&#8221; SI prefix symbol: hold down the Option key and type the &#8220;M&#8221; key on your keyboard.<\/p>\n<p>*Update* The instructions for Windows don&#8217;t appear to work in Office 2016, hence the strikeout below.<\/p>\n<p><del>If you&#8217;re using Windows or are trying to utilize other unicode symbols, the longer way of doing this may be more helpful. To produce an SI prefix symbol for micro and a superscript 3, this is <em>exactly<\/em> what you&#8217;ll need to type on the keyboard if you&#8217;d like to enter &#8220;35 ug\/m3&#8221; in an Excel cell (don&#8217;t type the &#8220;+&#8221; symbols or parentheses and what they contain):<\/del><\/p>\n<pre><del>3+5+spacebar+alt(hold it down)+0+1+8+1+(release alt key)enter<\/del><\/pre>\n<p><del>followed by:<\/del><\/p>\n<pre><del>g+\/+m+alt(hold it down)+0+1+7+9+(release alt key)enter<\/del><\/pre>\n<p><del>Another way to do this on a Mac is to enable Unicode Hex Input through System Preferences-&gt;Keyboard-&gt;Input Sources. If you anticipate you&#8217;ll be doing this frequently, check the box for &#8220;Show Input menu in menu bar&#8221;. After Unicode Hex Input is enabled, inside any Mac application enter an SI prefix symbol like micro by holding down the Alt key and then type in &#8220;00B5&#8221; or for a superscript 3, hold down the Alt key and type in the digits &#8220;00B3&#8221;. When you release the Alt key, your keyboard should return to normal entry.<\/del><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Most of my posts seem to be nerdy and this is more of the same, but if you&#8217;re into vapor intrusion and wanting to properly present results in Excel, you might find this helpful. While presenting VOC concentrations in micrograms &hellip; <a href=\"https:\/\/www.schwie.com\/brad\/?p=226\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-226","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=\/wp\/v2\/posts\/226","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=226"}],"version-history":[{"count":9,"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions"}],"predecessor-version":[{"id":497,"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=\/wp\/v2\/posts\/226\/revisions\/497"}],"wp:attachment":[{"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.schwie.com\/brad\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}