{"id":1967,"date":"2023-10-26T09:48:07","date_gmt":"2023-10-26T09:48:07","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/format\/"},"modified":"2023-12-06T06:17:13","modified_gmt":"2023-12-06T06:17:13","slug":"format","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/format\/","title":{"rendered":"Bagaimana cara menggunakan fungsi vba format?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2394594721\"><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 class=\"content-box-grey\">Fungsi VBA FORMAT tercantum dalam kategori teks fungsi VBA. Saat Anda menggunakannya dalam kode VBA, <strong>ia mengembalikan nilai<\/strong> yang diformat dalam format yang Anda tentukan. Sederhananya, Anda bisa menggunakannya untuk memformat ekspresi ke dalam format yang bisa Anda tentukan. Ada satu hal yang harus Anda perhatikan di sini, hasil yang dikembalikan adalah tipe data string.<\/p><h2 class=\"wp-block-heading\"> Sintaksis<\/h2><p> <strong>Format(Ekspresi,[Format],[Minggu Hari Pertama],[Tahun Minggu Pertama])<\/strong><\/p><h2 class=\"wp-block-heading\"> Argumen<\/h2><ul><li> <strong>Ekspresi<\/strong> : Ekspresi yang ingin Anda format.<\/li><li> <strong>[Format]<\/strong> : Format yang ingin Anda terapkan pada ekspresi [Ini adalah argumen opsional dan jika dihilangkan, VBA menggunakan Umum secara default].<\/li><li> <strong>[FirstDayOfWeek]<\/strong> : Sebuah string untuk menentukan hari pertama dalam seminggu [Ini adalah argumen opsional dan jika vbSunday dihilangkan secara default].<ul><li> vbUseSystemDayOfWeek \u2013 Tergantung pada pengaturan sistem.<\/li><li> vbMinggu \u2013 Minggu<\/li><li> vblunday \u2013 senin<\/li><li> vbSelasa \u2013 Selasa<\/li><li> vbRabu \u2013 Rabu<\/li><li> vbKamis \u2013 Kamis<\/li><li> vbJumat \u2013 Jumat<\/li><li> vbSabtu \u2013 Sabtu<\/li><\/ul><\/li><li> <strong>[FirstWeekOfYear]<\/strong> : Sebuah string untuk menentukan minggu pertama tahun ini [Ini adalah argumen opsional dan jika vbFirstJan1 dihilangkan secara default].<ul><li> vbSystem \u2013 Tergantung pada pengaturan sistem.<\/li><li> vbFirstJan1 \u2013 Minggu dimana tanggal 1 Januari terjadi.<\/li><li> vbFirstFourDays \u2013 Minggu pertama yang berisi setidaknya empat hari di tahun baru.<\/li><li> vbFirstFullWeek \u2013 Minggu penuh pertama di tahun baru.<\/li><\/ul><\/li><\/ul><h2 class=\"wp-block-heading\"> Contoh<\/h2><p> Untuk memahami secara praktis cara menggunakan fungsi VBA FORMAT, Anda perlu melihat contoh di bawah ini di mana kami telah menulis kode vba menggunakan fungsi tersebut: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><img loading=\"lazy\" decoding=\"async\" title=\"contoh-fungsi-vba-format\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"example-vba-format-function\" width=\"824\" height=\"423\"><\/figure><\/div><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub example_FORMAT() Range(\"B1\").Value = Format(Range(\"A1\"), \"Currency\") Range(\"B2\").Value = Format(Range(\"A2\"), \"Long Date\") Range(\"B3\").Value = Format(Range(\"A3\"), \"True\/False\") End Sub<\/code><\/pre><p> Pada contoh di atas, kami menggunakan FORMAT dengan tiga format berbeda yang telah ditentukan sebelumnya:<\/p><ol><li> Mengonversi nilai sel A1 ke format mata uang.<\/li><li> Mengubah tanggal di sel A2 menjadi tanggal panjang.<\/li><li> Mengubah angka di sel A3 menjadi Boolean.<\/li><\/ol><h2 class=\"wp-block-heading\"> Komentar<\/h2><ul><li> Anda juga dapat membuat format Anda sendiri untuk digunakan dalam argumen &#8220;format&#8221;. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-272\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/kanan\/\">VBA KANAN<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rtrim\/\">VBA RTRIM<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ruang-angkasa\/\">RUANG VBA<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/strcomp\/\">VBA STRCOMP<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/strkonv\/\">VBA STRCONV<\/a><\/li><\/ul><\/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-1967","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>Bagaimana cara menggunakan fungsi VBA FORMAT? (Sintaks + Contoh)<\/title>\n<meta name=\"description\" content=\"Pelajari cara menggunakan fungsi VBA FORMAT dengan sintaks, argumen dan contoh dengan kode contoh.\" \/>\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\/id\/format\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menggunakan fungsi VBA FORMAT? (Sintaks + Contoh)\" \/>\n<meta property=\"og:description\" content=\"Pelajari cara menggunakan fungsi VBA FORMAT dengan sintaks, argumen dan contoh dengan kode contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/format\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:17:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/format\/\",\"name\":\"Bagaimana cara menggunakan fungsi VBA FORMAT? (Sintaks + Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\",\"datePublished\":\"2023-10-26T09:48:07+00:00\",\"dateModified\":\"2023-12-06T06:17:13+00:00\",\"description\":\"Pelajari cara menggunakan fungsi VBA FORMAT dengan sintaks, argumen dan contoh dengan kode contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/format\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menggunakan fungsi vba format?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bagaimana cara menggunakan fungsi VBA FORMAT? (Sintaks + Contoh)","description":"Pelajari cara menggunakan fungsi VBA FORMAT dengan sintaks, argumen dan contoh dengan kode contoh.","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\/id\/format\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menggunakan fungsi VBA FORMAT? (Sintaks + Contoh)","og_description":"Pelajari cara menggunakan fungsi VBA FORMAT dengan sintaks, argumen dan contoh dengan kode contoh.","og_url":"https:\/\/exceladvisor.org\/id\/format\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:17:13+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/format\/","url":"https:\/\/exceladvisor.org\/id\/format\/","name":"Bagaimana cara menggunakan fungsi VBA FORMAT? (Sintaks + Contoh)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/format\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/format\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png","datePublished":"2023-10-26T09:48:07+00:00","dateModified":"2023-12-06T06:17:13+00:00","description":"Pelajari cara menggunakan fungsi VBA FORMAT dengan sintaks, argumen dan contoh dengan kode contoh.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/format\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/format\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/format\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/exemple-de-fonction-de-format-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/format\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menggunakan fungsi vba format?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1967"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1967\/revisions"}],"predecessor-version":[{"id":2583,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1967\/revisions\/2583"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}