{"id":50651,"date":"2017-01-05T11:21:33","date_gmt":"2017-01-05T10:21:33","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50651"},"modified":"2017-01-05T11:21:33","modified_gmt":"2017-01-05T10:21:33","slug":"text-functie-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/text-functie-in-excel\/","title":{"rendered":"TEXT functie in Excel"},"content":{"rendered":"<p>V. Met de TEXT functie in Excel kan ik een datum omzetten in een weekdag of een maand. Maar als ik TEXT intik, wordt dat TEKST en krijg ik een foutmelding. Wat kan ik doen?<\/p>\n<p>A.Wat je ziet, is het gevolg van autocorrectie. De eenvoudigste oplossing is om te dubbelklikken op het TEXT element in de uitvouwlijst die verschijnt tijdens het typen.<\/p>\n<p><a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-text-functie.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50652\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-text-functie-300x96.png\" alt=\"\" width=\"300\" height=\"96\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-text-functie-300x96.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-text-functie.png 452w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Alternatieven:<\/p>\n<ul>\n<li>met F2 de functie bewerken en TEKST terug wijzigen in TEXT<\/li>\n<li>of Excel in het Nederlands zetten via <em>File, Options, Language &#8211; Dutch<\/em> &#8211; <em>Set as default<\/em><br \/>\n<a href=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-language.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50653\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-language-300x217.png\" alt=\"\" width=\"300\" height=\"217\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-language-300x217.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-language-768x556.png 768w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2017\/01\/xl-language.png 936w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<\/ul>\n<p>En: je kan de weekdag weergeven\/berekenen met =TEXT(<em>datum<\/em>,&#8221;dddd&#8221;), de maand met =TEXT(<em>datum<\/em>,&#8221;mmmm&#8221;).<\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Met de TEXT functie in Excel kan ik een datum omzetten in een weekdag of een maand. Maar als ik TEXT intik, wordt dat TEKST en krijg ik een foutmelding. Wat kan ik doen? A.Wat je ziet, is het gevolg van autocorrectie. De eenvoudigste oplossing is om te dubbelklikken<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[54,79,10],"tags":[],"class_list":["post-50651","post","type-post","status-publish","format-standard","hentry","category-excel","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 18:36:39","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\/50651","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=50651"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50651\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50651"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50651"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50651"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}