{"id":3673,"date":"2023-09-25T21:25:39","date_gmt":"2023-09-25T21:25:39","guid":{"rendered":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/"},"modified":"2023-12-03T13:05:36","modified_gmt":"2023-12-03T13:05:36","slug":"wahrungsformat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/","title":{"rendered":"Wie wende ich das w\u00e4hrungsformat \u00fcber eine excel-verkn\u00fcpfung an?"},"content":{"rendered":"<div class=\"excel-vor-dem-inhalt\" id=\"excel-3685661248\"><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 verf\u00fcgt \u00fcber mehrere Zahlenformate und das W\u00e4hrungsformat ist eines davon. Das W\u00e4hrungsformat wird verwendet, um das W\u00e4hrungssymbol am Anfang numerischer Werte hinzuzuf\u00fcgen. Benutzer k\u00f6nnen ein beliebiges W\u00e4hrungssymbol ausw\u00e4hlen, das sie hinzuf\u00fcgen m\u00f6chten.<\/p><p> Excel verwendet standardm\u00e4\u00dfig die Standardw\u00e4hrung basierend auf unserer Systemregion, sodass diese f\u00fcr Benutzer in verschiedenen Regionen unterschiedlich sein kann.<\/p><p> Der Benutzer kann jedoch ein beliebiges W\u00e4hrungssymbol als Standardw\u00e4hrungssymbol ausw\u00e4hlen und festlegen, sodass Excel dieses W\u00e4hrungssymbol als Standard hinzuf\u00fcgt, wenn der Benutzer ein W\u00e4hrungsformat \u00fcber eine Tastenkombination anwendet.<\/p><h2 class=\"wp-block-heading\"> Tastenkombination zum Anwenden des W\u00e4hrungsformats in Excel<\/h2><p> Die Tastenkombination zum Anwenden des W\u00e4hrungsformats ist unten aufgef\u00fchrt:<\/p><p> <kbd>Strg<\/kbd> + <kbd>Umschalt<\/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=\"W\u00e4hrungsformat-Tastaturk\u00fcrzel\" width=\"784\" height=\"307\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Schritte zum Anwenden des W\u00e4hrungsformats mithilfe einer Tastenkombination<\/h2><ol><li> W\u00e4hlen Sie zun\u00e4chst die Zelle, Spalte(n) oder den Zellbereich aus, auf die Sie das allgemeine Zahlenformat anwenden oder in das W\u00e4hrungsformat \u00e4ndern m\u00f6chten.<\/li><li> Nach der Auswahl dr\u00fccken Sie einfach gleichzeitig die Tasten <kbd>Strg<\/kbd> + <kbd>Umschalt<\/kbd> + <kbd>$<\/kbd> und Sie erhalten die Konvertierung des Zahlenformats in das W\u00e4hrungsformat, indem Sie das W\u00e4hrungssymbol am Anfang der Zahlen in jeder ausgew\u00e4hlten Zelle hinzuf\u00fcgen. <\/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=\"W\u00e4hrungsformat anwenden\" width=\"431\" height=\"251\"><\/figure><\/div><p class=\"mynote\"> Um ein anderes W\u00e4hrungssymbol als Standardw\u00e4hrungssymbol festzulegen, m\u00fcssen Sie zu Einstellungen \u2192 Sprach- und Regionseinstellungen \u2192 unter Regionseinstellungen \u2192 auf \u201eZus\u00e4tzliche Einstellungen\u201c klicken \u2192 Registerkarte \u201eW\u00e4hrung\u201c ausw\u00e4hlen \u2192 die W\u00e4hrung ausw\u00e4hlen, f\u00fcr die Sie eine Standardw\u00e4hrung festlegen m\u00f6chten \u2192 klicken Bewerben und ok. <\/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=\"Anpassen-Format\" 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\/de\/tastaturkurzel\/\">Tastenkombinationen f\u00fcr Excel-PDFs<\/a><h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> Weitere Verkn\u00fcpfungen <\/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\/de\/takt-1\/\">Stange<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/index-2\/\">Hinweis<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/exponent\/\">Aussteller<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/hakchen-1\/\">H\u00e4kchen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/de\/im-zentrum-anordnen\/\">Im Zentrum anordnen<\/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-3673","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>Wie wende ich das W\u00e4hrungsformat \u00fcber eine Excel-Verkn\u00fcpfung an?<\/title>\n<meta name=\"description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Tastenkombination verwenden, mit der Sie in Excel das Prozentformat anwenden k\u00f6nnen\" \/>\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\/de\/wahrungsformat\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Wie wende ich das W\u00e4hrungsformat \u00fcber eine Excel-Verkn\u00fcpfung an?\" \/>\n<meta property=\"og:description\" content=\"In diesem Tutorial erfahren Sie, wie Sie eine Tastenkombination verwenden, mit der Sie in Excel das Prozentformat anwenden k\u00f6nnen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-03T13:05:36+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=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/\",\"name\":\"Wie wende ich das W\u00e4hrungsformat \u00fcber eine Excel-Verkn\u00fcpfung an?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#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-03T13:05:36+00:00\",\"description\":\"In diesem Tutorial erfahren Sie, wie Sie eine Tastenkombination verwenden, mit der Sie in Excel das Prozentformat anwenden k\u00f6nnen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#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\/de\/wahrungsformat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/exceladvisor.org\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Wie wende ich das w\u00e4hrungsformat \u00fcber eine excel-verkn\u00fcpfung an?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#website\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"name\":\"Excel Advisor\",\"description\":\"Ihr Leitfaden zur Datendominanz\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/de\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Wie wende ich das W\u00e4hrungsformat \u00fcber eine Excel-Verkn\u00fcpfung an?","description":"In diesem Tutorial erfahren Sie, wie Sie eine Tastenkombination verwenden, mit der Sie in Excel das Prozentformat anwenden k\u00f6nnen","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\/de\/wahrungsformat\/","og_locale":"de_DE","og_type":"article","og_title":"Wie wende ich das W\u00e4hrungsformat \u00fcber eine Excel-Verkn\u00fcpfung an?","og_description":"In diesem Tutorial erfahren Sie, wie Sie eine Tastenkombination verwenden, mit der Sie in Excel das Prozentformat anwenden k\u00f6nnen","og_url":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-03T13:05:36+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":{"Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/","url":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/","name":"Wie wende ich das W\u00e4hrungsformat \u00fcber eine Excel-Verkn\u00fcpfung an?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#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-03T13:05:36+00:00","description":"In diesem Tutorial erfahren Sie, wie Sie eine Tastenkombination verwenden, mit der Sie in Excel das Prozentformat anwenden k\u00f6nnen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/de\/wahrungsformat\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/wahrungsformat\/#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\/de\/wahrungsformat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/exceladvisor.org\/de\/"},{"@type":"ListItem","position":2,"name":"Wie wende ich das w\u00e4hrungsformat \u00fcber eine excel-verkn\u00fcpfung an?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/de\/#website","url":"https:\/\/exceladvisor.org\/de\/","name":"Excel Advisor","description":"Ihr Leitfaden zur Datendominanz","publisher":{"@id":"https:\/\/exceladvisor.org\/de\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/de\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/de\/wp-content\/uploads\/2023\/11\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/de\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3673","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/comments?post=3673"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3673\/revisions"}],"predecessor-version":[{"id":4404,"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/pages\/3673\/revisions\/4404"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/de\/wp-json\/wp\/v2\/media?parent=3673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}