{"id":29079,"date":"2026-04-30T13:52:30","date_gmt":"2026-04-30T13:52:30","guid":{"rendered":"https:\/\/support.buildsoft.eu\/?post_type=ht_kb&#038;p=29079"},"modified":"2026-04-30T13:52:33","modified_gmt":"2026-04-30T13:52:33","slug":"how-to-change-the-decimal-separator-in-windows","status":"publish","type":"ht_kb","link":"https:\/\/support.buildsoft.eu\/es\/knowledge-base\/how-to-change-the-decimal-separator-in-windows\/","title":{"rendered":"How to change the decimal separator\u00a0in Windows"},"content":{"rendered":"\n<p>The way numbers are reprented in a table (doens&#8217;t matter if it&#8217;s in Excel or a Diamonds table), depends on the number format imposed in Windows.<\/p>\n\n\n\n<p>You can access this setting by going to <em>Control Panel<\/em> > <em>Clock and region<\/em> > <em>Change data, time or number formats<\/em>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2026\/04\/WindowsClockRegion.png\"><img decoding=\"async\" loading=\"lazy\" width=\"795\" height=\"363\" src=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2026\/04\/WindowsClockRegion.png\" alt=\"\" class=\"wp-image-29077\"\/><\/a><\/figure><\/div>\n\n\n<p>The following dialog will appear:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2026\/04\/WindowsClockRegion2.png\"><img decoding=\"async\" loading=\"lazy\" width=\"484\" height=\"544\" src=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2026\/04\/WindowsClockRegion2.png\" alt=\"\" class=\"wp-image-29078\"\/><\/a><\/figure><\/div>\n\n\n<p>Choose \u00abMore settings\u00bb. The following dialog appears:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2026\/04\/WindowsClockRegion3.png\"><img decoding=\"async\" loading=\"lazy\" width=\"463\" height=\"600\" src=\"https:\/\/support.buildsoft.eu\/wp-content\/uploads\/2026\/04\/WindowsClockRegion3.png\" alt=\"\" class=\"wp-image-29076\"\/><\/a><\/figure><\/div>\n\n\n<p>In this dialog you can impose the separator for the decimals. It often causes trouble in Diamonds\/ Excel when the separator is set to \u00bb . \u00bb instead of \u00bb , \u00ab.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The way numbers are reprented in a table (doens&#8217;t matter if it&#8217;s in Excel or a Diamonds table), depends on the number format imposed in Windows. You can access this setting by going to Control Panel > Clock and region > Change data, time or number formats. The following dialog&#8230;<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[62],"ht-kb-tag":[],"_links":{"self":[{"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/ht-kb\/29079"}],"collection":[{"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/comments?post=29079"}],"version-history":[{"count":1,"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/ht-kb\/29079\/revisions"}],"predecessor-version":[{"id":29080,"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/ht-kb\/29079\/revisions\/29080"}],"wp:attachment":[{"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/media?parent=29079"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/ht-kb-category?post=29079"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.buildsoft.eu\/es\/wp-json\/wp\/v2\/ht-kb-tag?post=29079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}