{"id":2181,"date":"2023-09-25T21:25:39","date_gmt":"2023-09-25T21:25:39","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/"},"modified":"2023-12-06T05:49:17","modified_gmt":"2023-12-06T05:49:17","slug":"valuta-formaat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/","title":{"rendered":"Hoe kan ik het valutaformaat toepassen via de excel-snelkoppeling?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-684577044\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Excel heeft verschillende getalformaten en het valutaformaat is daar \u00e9\u00e9n van. Het valutaformaat wordt gebruikt om het valutasymbool aan het begin van numerieke waarden toe te voegen. Gebruikers kunnen elk valutasymbool kiezen dat ze willen toevoegen.<\/p><p> Excel gebruikt standaard de standaardvaluta op basis van onze systeemregio, dus deze kan voor gebruikers in verschillende regio&#8217;s verschillend zijn.<\/p><p> Maar de gebruiker kan elk valutasymbool kiezen en instellen als standaardvalutasymbool, zodat telkens wanneer de gebruiker de valutanotatie toepast met behulp van een sneltoets, Excel dat valutasymbool als standaard toevoegt.<\/p><h2 class=\"wp-block-heading\"> Sneltoets om valutaformaat toe te passen in Excel<\/h2><p> De sneltoets om het valutaformaat toe te passen wordt hieronder vermeld:<\/p><p> <kbd>Ctrl<\/kbd> + <kbd>Shift<\/kbd> + <kbd>$<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72763\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets voor valutaformaat\" width=\"784\" height=\"307\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen om het valutaformaat toe te passen met behulp van een sneltoets<\/h2><ol><li> Selecteer eerst de cel, kolom(men) of celbereik waarop u de algemene getalnotatie wilt toepassen of wijzig deze in valutanotatie.<\/li><li> Eenmaal geselecteerd, drukt u eenvoudigweg op de toetsen <kbd>Ctrl<\/kbd> + <kbd>Shift<\/kbd> + <kbd>$<\/kbd> en u krijgt het getalformaat geconverteerd naar valutaformaat door het valutasymbool toe te voegen aan het begin van de getallen in elke geselecteerde cel. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72764\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-appliquer-le-format-monetaire.png\" sizes=\"auto, \" srcset=\"\" alt=\"valuta-formaat toepassen\" width=\"431\" height=\"251\"><\/figure><\/div><p class=\"mynote\"> Om een ander valutasymbool als standaard valutasymbool in te stellen, gaat u naar instellingen \u2192 taal- en regio-instellingen \u2192 onder regio-instellingen \u2192 klik op \u201cAanvullende instellingen\u201d \u2192 selecteer het tabblad Valuta \u2192 selecteer de valuta waarvoor u een standaardvaluta wilt instellen \u2192 klik op toepassen en ok\u00e9. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72765\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-personnaliser-le-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"aanpassen-formaat\" width=\"403\" height=\"516\"><\/figure><\/div><div class=\"gb-container gb-container-2116538e gb-container-mt\"> <a class=\"gb-button gb-button-f7d2c131 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/toetsenbord-sneltoetsen\/\">Sneltoetsen voor Excel PDF-toetsenbord<\/a><h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> Meer snelkoppelingen <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-edeef538 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6ab6fbc6\"><div class=\"gb-container gb-container-6ab6fbc6\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/balk-1\/\">Hengel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/index-2\/\">Tip<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/exponent\/\">Exposant<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/vinkje-1\/\">Vinkje<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tekst-in-het-midden-uitlijnen\/\">Tekst in het midden uitlijnen<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-766d598b\"><div class=\"gb-container gb-container-766d598b\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-2181","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hoe kan ik het valutaformaat toepassen via de Excel-snelkoppeling?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt die u in Excel kunt gebruiken om de procentnotatie toe te passen\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe kan ik het valutaformaat toepassen via de Excel-snelkoppeling?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt die u in Excel kunt gebruiken om de procentnotatie toe te passen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:49:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/\",\"name\":\"Hoe kan ik het valutaformaat toepassen via de Excel-snelkoppeling?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png\",\"datePublished\":\"2023-09-25T21:25:39+00:00\",\"dateModified\":\"2023-12-06T05:49:17+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een sneltoets gebruikt die u in Excel kunt gebruiken om de procentnotatie toe te passen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe kan ik het valutaformaat toepassen via de excel-snelkoppeling?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe kan ik het valutaformaat toepassen via de Excel-snelkoppeling?","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt die u in Excel kunt gebruiken om de procentnotatie toe te passen","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe kan ik het valutaformaat toepassen via de Excel-snelkoppeling?","og_description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt die u in Excel kunt gebruiken om de procentnotatie toe te passen","og_url":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:49:17+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/","url":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/","name":"Hoe kan ik het valutaformaat toepassen via de Excel-snelkoppeling?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png","datePublished":"2023-09-25T21:25:39+00:00","dateModified":"2023-12-06T05:49:17+00:00","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt die u in Excel kunt gebruiken om de procentnotatie toe te passen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/valuta-formaat\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-au-format-monetaire.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/valuta-formaat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe kan ik het valutaformaat toepassen via de excel-snelkoppeling?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=2181"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2181\/revisions"}],"predecessor-version":[{"id":2604,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2181\/revisions\/2604"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}