{"id":1110,"date":"2013-03-01T14:46:52","date_gmt":"2013-03-01T07:46:52","guid":{"rendered":"https:\/\/sebayan9.wordpress.com\/?p=1110"},"modified":"2013-03-01T14:46:52","modified_gmt":"2013-03-01T07:46:52","slug":"system-separator-in-excel-2007","status":"publish","type":"post","link":"https:\/\/rachmadona.net\/?p=1110","title":{"rendered":"System Separator in Excel 2007"},"content":{"rendered":"<p>Recently, I had problem in Excel 2007. The problem was related about System Separator and pasting number. When user try to paste number format from the page in browser, the result show like picture below:<\/p>\n<p>Source: Number format in page at browser<\/p>\n<p><a href=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot225.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image:none;border-bottom:0;border-left:0;padding-left:0;padding-right:0;display:inline;border-top:0;border-right:0;padding-top:0;\" title=\"ScreenShot225\" border=\"0\" alt=\"ScreenShot225\" src=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot225_thumb.jpg\" width=\"348\" height=\"292\"\/><\/a><\/p>\n<p>Destination: Excel 2007<\/p>\n<p><a href=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot226.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image:none;border-bottom:0;border-left:0;padding-left:0;padding-right:0;display:inline;border-top:0;border-right:0;padding-top:0;\" title=\"ScreenShot226\" border=\"0\" alt=\"ScreenShot226\" src=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot226_thumb.jpg\" width=\"279\" height=\"245\"\/><\/a><\/p>\n<p>Actually there is no error show, but if you want to summarize or calculate the cells it\u2019s gonna show error because it can\u2019t be calculated. Why? Because the type of cells isn\u2019t number, but text.<\/p>\n<p>So, how to paste numbering format directly into similar format\u2014nothing change at Excel, especially Excel 2007. The Answer is using System Separator\u2014Decimal separator &amp; Thousand separator.<\/p>\n<p>All you have to do is go to the Excel Options then choose Advance. At the tab System Separator, switch the value of Decimal separator &amp; Thousand separator.<\/p>\n<p><a href=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot228.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image:none;border-bottom:0;border-left:0;padding-left:0;padding-right:0;display:inline;border-top:0;border-right:0;padding-top:0;\" title=\"ScreenShot228\" border=\"0\" alt=\"ScreenShot228\" src=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot228_thumb.jpg\" width=\"299\" height=\"182\"\/><\/a><\/p>\n<p>If you configure correctly, the result gonna show like this.<\/p>\n<p><a href=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot229.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image:none;border-bottom:0;border-left:0;padding-left:0;padding-right:0;display:inline;border-top:0;border-right:0;padding-top:0;\" title=\"ScreenShot229\" border=\"0\" alt=\"ScreenShot229\" src=\"http:\/\/sebayan9.files.wordpress.com\/2013\/03\/screenshot229_thumb.jpg\" width=\"307\" height=\"202\"\/><\/a><\/p>\n<p>Finally you can calculated the cells.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently, I had problem in Excel 2007. The problem was related about System Separator and pasting number. When user try to paste number format from the page in browser, the result show like picture below: Source: Number format in page at browser Destination: Excel 2007 Actually there is no error show, but if you want&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1111,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,20],"tags":[136,274,277,424,437],"class_list":["post-1110","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer","category-tips-trick","tag-decimal-separator","tag-microsoft-excel-2007","tag-miscrosoft-excel","tag-system-separator","tag-thousand-separator"],"_links":{"self":[{"href":"https:\/\/rachmadona.net\/index.php?rest_route=\/wp\/v2\/posts\/1110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rachmadona.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rachmadona.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rachmadona.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/rachmadona.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1110"}],"version-history":[{"count":0,"href":"https:\/\/rachmadona.net\/index.php?rest_route=\/wp\/v2\/posts\/1110\/revisions"}],"wp:attachment":[{"href":"https:\/\/rachmadona.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rachmadona.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rachmadona.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}