{"id":371,"date":"2016-03-01T09:14:47","date_gmt":"2016-03-01T14:14:47","guid":{"rendered":"http:\/\/www.chelseaschools.com\/kbase\/?p=371"},"modified":"2018-11-16T13:53:10","modified_gmt":"2018-11-16T18:53:10","slug":"adding-unit-labels-to-google-sheets-without-messing-up-sorting","status":"publish","type":"ht_kb","link":"https:\/\/www.cpskb.com\/kbase\/knowledge-base\/adding-unit-labels-to-google-sheets-without-messing-up-sorting\/","title":{"rendered":"Adding unit labels to Google Sheets without messing up sorting"},"content":{"rendered":"<p>Google Sheets has come a long way, so far that I consider it a viable alternative to Excel. I did, however, bump into a little annoyance recently involving scientific data collected in a spreadsheet. Luckily it has an easy solution.<\/p>\n<p>Say you&#8217;re collecting some measurements and you want to include &#8220;cm&#8221; after each value. If you add cm to the data (1cm, 2cm, 2.4cm, 12cm), you&#8217;ll notice that sorting the data results in some unexpected orderings. To get around this, you can set up a custom format for the column of data.<\/p>\n<ol>\n<li>Highlight the data you want to format.<\/li>\n<li>Click the <strong>Format<\/strong> menu and hover over \u201cNumber\u201d (or click Number format\u00a0<img decoding=\"async\" src=\"https:\/\/lh3.ggpht.com\/tUcDBqU8NaFvGwwhLjMyStBy7G-V_a_gLfm9LLVD-3feXbX77vlL_S1Bmgsq9rZY-SGWMIZ6Eg=w25\" alt=\"\" height=\"auto\" \/>\u00a0in the toolbar).<\/li>\n<li>Hover over &#8220;More Formats.&#8221;<\/li>\n<li>Select <strong>Custom number format<\/strong>.<\/li>\n<li>Search in the menu text box to select a format. You can also add your own custom number format into the text box. In our case we would add (0 &#8220;cm&#8221;) without the parentheses in order to have &#8220;cm&#8221; added at the end of each value.<\/li>\n<li>Click <strong>Apply<\/strong>.<\/li>\n<\/ol>\n<p>This works fine as long as all the units are cm. Have to put cm, mm, etc., in the same column? Sorry&#8230; I haven&#8217;t figured that out yet.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets has come a long way, so far that I consider it a viable alternative to Excel. I did, however, bump into a little annoyance recently involving scientific data collected in a spreadsheet. Luckily it has an easy solution. Say you&#8217;re collecting some measurements and you want to include&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[99],"ht-kb-tag":[],"class_list":["post-371","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-google-drive-and-docs"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/ht-kb\/371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/comments?post=371"}],"version-history":[{"count":0,"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/ht-kb\/371\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/media?parent=371"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/ht-kb-category?post=371"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.cpskb.com\/kbase\/wp-json\/wp\/v2\/ht-kb-tag?post=371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}