{"id":315,"date":"2023-01-14T15:53:46","date_gmt":"2023-01-14T15:53:46","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=315"},"modified":"2023-01-14T15:53:48","modified_gmt":"2023-01-14T15:53:48","slug":"how-to-change-1000-separator-to-show-comma-after-3-digits-instead-of-2-digits-in-excel","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/how-to-change-1000-separator-to-show-comma-after-3-digits-instead-of-2-digits-in-excel\/","title":{"rendered":"How to change 1000 separator to show comma after 3 digits instead of 2 digits in Excel"},"content":{"rendered":"<p>People from some countries like India face the difficulty of Excel showing comma separation after 2 digits instead of 3 digits. For Example, 3 Million US dollar being displayed as $30,00,000 instead of $3,000,000.<br \/>\nTo solve this issue go to &#8220;Language and Region&#8221; in Windows (do a search for the term &#8220;Language and Region&#8221; in start menu of Windows).<br \/>\nScroll down and go to Region.<br \/>\nIn the regional format, choose English (United States) or any other option that support the 3 digit separator instead of the current selection.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-full wp-image-316\" src=\"https:\/\/www.howtoexcel.info\/Excel\/wp-content\/uploads\/2023\/01\/1000-seperator-issue.png\" alt=\"\" width=\"1212\" height=\"589\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>People from some countries like India face the difficulty of Excel showing comma separation after 2 digits instead of 3 digits. For Example, 3 Million US dollar being displayed as $30,00,000 instead of $3,000,000. To solve this issue go to &#8220;Language and Region&#8221; in Windows (do a search for the term &#8220;Language and Region&#8221; in &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.howtoexcel.info\/Excel\/how-to-change-1000-separator-to-show-comma-after-3-digits-instead-of-2-digits-in-excel\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;How to change 1000 separator to show comma after 3 digits instead of 2 digits in Excel&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/315"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/comments?post=315"}],"version-history":[{"count":2,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/315\/revisions"}],"predecessor-version":[{"id":318,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/315\/revisions\/318"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=315"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=315"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}