{"id":51873,"date":"2017-10-13T18:34:30","date_gmt":"2017-10-13T17:34:30","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=51873"},"modified":"2017-10-07T18:46:06","modified_gmt":"2017-10-07T17:46:06","slug":"excel-gebruikt-engelse-notatie","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/excel-gebruikt-engelse-notatie\/","title":{"rendered":"Excel gebruikt Engelse notatie"},"content":{"rendered":"<p>V. Excel gebruikt Angelsaksische notatie voor data, punten voor komma&#8217;s en wil geen puntkomma&#8217;s in Excel functies. Wat kan ik doen?<\/p>\n<p>A. Excel zegt zelf of hij komma&#8217;s of puntkomma&#8217;s verwacht in functies. Het programma vraagt aan Windows wat de gebruiker (jij dus) als lijstscheidingsteken heeft ingesteld.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51874\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie-1-300x120.png\" alt=\"\" width=\"300\" height=\"120\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie-1-300x120.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie-1.png 382w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>De interfacetaal van Excel kan je instellen via <em>File, Options, Language, Display Language \/ Bestand, Opties, Taal, Weergavetaal<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51875\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie2-1-300x246.png\" alt=\"\" width=\"300\" height=\"246\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie2-1-300x246.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie2-1-768x630.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie2-1.png 826w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>De datumnotatie en het lijstscheidingsteken stel je zo\u00c2\u00a0 in:<\/p>\n<ul>\n<li>Klik op de taalafkorting op de taakbalk en kies <em>Taalvoorkeuren<\/em>.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51876\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie3-1.png\" alt=\"\" width=\"298\" height=\"205\" \/><br \/>\nOf Start, <em>Instellingen, Tijd en taal.<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51877\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie4-1-300x237.png\" alt=\"\" width=\"300\" height=\"237\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie4-1-300x237.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie4-1-768x606.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie4-1.png 802w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Kies daar <em>Datum en tijd, Datum- en tijdnotaties wijzigen<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51878\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie5-1-300x226.png\" alt=\"\" width=\"300\" height=\"226\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie5-1-300x226.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie5-1-768x579.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie5-1.png 786w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/li>\n<li>Vervolgens kies je voor <em>Nederlands (Belgi\u00eb)<\/em><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-51879\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie6-1-267x300.png\" alt=\"\" width=\"267\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie6-1-267x300.png 267w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/10\/xl-usnotatie6-1.png 484w\" sizes=\"auto, (max-width: 267px) 100vw, 267px\" \/><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Excel gebruikt Angelsaksische notatie voor data, punten voor komma&#8217;s en wil geen puntkomma&#8217;s in Excel functies. Wat kan ik doen? A. Excel zegt zelf of hij komma&#8217;s of puntkomma&#8217;s verwacht in functies. Het programma vraagt aan Windows wat de gebruiker (jij dus) als lijstscheidingsteken heeft ingesteld. De interfacetaal van<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":88,"footnotes":""},"categories":[464,54,375,79,10,246],"tags":[],"class_list":["post-51873","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-odisee","category-office","category-office-2010"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 09:00:18","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51873","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=51873"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/51873\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=51873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=51873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=51873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}