{"id":59297,"date":"2021-09-07T17:07:46","date_gmt":"2021-09-07T16:07:46","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=59297"},"modified":"2024-03-18T14:26:03","modified_gmt":"2024-03-18T13:26:03","slug":"getallen-uitschrijven-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/getallen-uitschrijven-in-excel\/","title":{"rendered":"Getallen uitschrijven in Excel"},"content":{"rendered":"<p>Soms wil je een getal uitschrijven in letters.Voor juridische documenten, bijvoorbeeld. Excel kan dat doen voor jou.<\/p>\n<ul>\n<li>Er is een oudere Excel invoegapplicatie NBlettre.xla die nog te vinden is op het net.<\/li>\n<li>Niet meer beschikbaar? <a href=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/09\/NbLettre.xla\">Ik heb een kopij.<\/a><\/li>\n<li>Je kan die invoegtoepassing installeren (zie hier hoe), en je kan werken met de functie <strong>ConvNumberLetter<\/strong><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-59299\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/09\/Screenshot-2021-07-06-20.23.49.png\" alt=\"\" width=\"723\" height=\"388\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/09\/Screenshot-2021-07-06-20.23.49.png 723w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/09\/Screenshot-2021-07-06-20.23.49-300x161.png 300w\" sizes=\"auto, (max-width: 723px) 100vw, 723px\" \/><\/li>\n<li>Je kan ook een macro maken in Excel die de conversie voor jou kan doen &#8211; zie de details (en de code) in<br \/>\n<em>Getallen converteren naar woorden<\/em><br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/getallen-converteren-naar-woorden-a0d166fb-e1ea-4090-95c8-69442cd55d98\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/getallen-converteren-naar-woorden-a0d166fb-e1ea-4090-95c8-69442cd55d98<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Soms wil je een getal uitschrijven in letters.Voor juridische documenten, bijvoorbeeld. Excel kan dat doen voor jou. Er is een oudere Excel invoegapplicatie NBlettre.xla die nog te vinden is op het net. Niet meer beschikbaar? Ik heb een kopij. Je kan die invoegtoepassing installeren (zie hier hoe), en je kan<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":444,"footnotes":""},"categories":[464,54,375,79,10],"tags":[],"class_list":["post-59297","post","type-post","status-publish","format-standard","hentry","category-ebp","category-excel","category-excel-office-2010","category-odisee","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-24 06:03:29","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\/59297","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=59297"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/59297\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=59297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=59297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=59297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}