{"id":6840,"date":"2015-06-04T12:00:58","date_gmt":"2015-06-04T10:00:58","guid":{"rendered":"http:\/\/www.ub.edu\/retrucs\/?p=6840"},"modified":"2024-10-29T13:49:16","modified_gmt":"2024-10-29T12:49:16","slug":"com-puc-canviar-els-simbols-separadors-de-decimals-i-milers-a-lexcel","status":"publish","type":"post","link":"https:\/\/www.ub.edu\/retrucs\/com-puc-canviar-els-simbols-separadors-de-decimals-i-milers-a-lexcel\/","title":{"rendered":"En un Excel en angl\u00e8s vull canviar el separador de decimals, com ho puc fer?"},"content":{"rendered":"<p>Per defecte l&#8217;Excel usa el separador de milers i decimals configurat en el sistema. Aix\u00f2 vol dir que, si el sistema t\u00e9 definida\u00a0una llengua que fa servir la coma com a separador de decimals, quan introdu\u00efu un nombre amb decimals sempre apareixer\u00e0 una coma, encara que ho feu prement la tecla corresponent\u00a0del teclat num\u00e8ric, on apareix un punt en comptes d&#8217;una coma.<\/p>\n<p>Si necessiteu\u00a0canviar el s\u00edmbol per separar\u00a0decimals (perqu\u00e8 feu una traducci\u00f3 a l&#8217;angl\u00e8s, per exemple, i voleu fer servir el punt en comptes de la coma), heu de canviar un par\u00e0metre de les opcions, tal com podeu veure en el\u00a0v\u00eddeo.<\/p>\n<p>Cal dir, per\u00f2, que aquesta opci\u00f3 no queda lligada al document, sin\u00f3 que afecta la configuraci\u00f3 personal del programa\u00a0i, per tant, qualsevol usuari que obri el document veur\u00e0 el s\u00edmbol que tingui definit en\u00a0la seva configuraci\u00f3.<\/p>\n<p><iframe loading=\"lazy\" title=\"Canvi de s\u00edmbol separador de decimals a l\u2019Excel 2013\" width=\"660\" height=\"371\" src=\"https:\/\/www.youtube.com\/embed\/hu3smXzefSI?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Per defecte l&#8217;Excel usa el separador de milers i decimals configurat en el sistema. Aix\u00f2 vol dir que, si el sistema t\u00e9 definida\u00a0una llengua que fa servir la coma com a separador de decimals, quan introdu\u00efu un nombre amb decimals sempre apareixer\u00e0 una coma, encara que ho feu prement la &#8230;<\/p>\n","protected":false},"author":4,"featured_media":15865,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"chat","meta":{"_acf_changed":false,"footnotes":""},"categories":[294,1],"tags":[101,108,26],"class_list":["post-6840","post","type-post","status-publish","format-chat","has-post-thumbnail","hentry","category-excel","category-retrucs","tag-text","tag-excel","tag-simbols","post_format-post-format-chat","column","threecol","has-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/posts\/6840","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/comments?post=6840"}],"version-history":[{"count":0,"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/posts\/6840\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/media\/15865"}],"wp:attachment":[{"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/media?parent=6840"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/categories?post=6840"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ub.edu\/retrucs\/wp-json\/wp\/v2\/tags?post=6840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}