{"id":1847,"date":"2023-10-31T16:41:03","date_gmt":"2023-10-31T16:41:03","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/"},"modified":"2023-12-06T06:15:56","modified_gmt":"2023-12-06T06:15:56","slug":"format-angka-akuntansi","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/","title":{"rendered":"Bagaimana cara mengatur format angka akuntansi di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3066447934\"><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>Microsoft Excel banyak digunakan untuk tujuan bisnis dan akuntansi dan ketika pengguna menggunakan Excel untuk tujuan akuntansi, kumpulan data mereka biasanya memiliki sekumpulan angka.<\/p><p> Dan mereka mungkin ingin mengkonversi angka dari format angka standar ke format angka akuntansi untuk membuat kumpulan data lebih jelas dan lebih cocok untuk akuntansi.<\/p><p> Format angka akuntansi mengubah format angka umum dengan menambahkan simbol mata uang di ujung kiri sel, pemisah ribuan, dan dua tempat desimal (0,00) di akhir setiap angka.<\/p><p> Format angka akuntansi juga menampilkan nilai nol (0) sebagai tanda hubung \u201c-\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-65916\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"format akuntansi-vs-umum-numerik\" width=\"585\" height=\"130\"><\/figure><\/div><p> Di bawah ini kami memberikan beberapa langkah cepat dan mudah untuk menerapkan format angka akuntansi di Excel.<\/p><h2 class=\"wp-block-heading\"> Terapkan format nomor akuntansi menggunakan tombol Format Nomor Akuntansi<\/h2><ol><li> Pertama, pilih sel atau rentang dengan angka yang ingin Anda format.<\/li><li> Setelah itu, buka tab \u201cBeranda\u201d lalu klik tombol \u201cFormat Nomor Rekening\u201d.<\/li><li> Sekarang klik format akuntansi dengan simbol mata uang dari daftar drop-down yang ingin Anda tambahkan. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-tombol-format-akuntansi-nomor-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-bouton-de-format-de-numero-comptable-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"accounting-number-format-button\" width=\"770\" height=\"297\"><\/li><li> Pada titik ini, sel atau rentang yang dipilih diubah menjadi \u201cFormat Angka Akuntansi\u201d dengan menambahkan simbol mata uang, pemisah ribuan angka, dan dua tempat desimal ke nilai numerik. <br><img loading=\"lazy\" decoding=\"async\" title=\"Format 3-nilai-dalam-akuntansi-angka-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeurs-au-format-numero-comptable-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"201\" height=\"273\"><\/li><li> Untuk menambah atau mengurangi nilai desimal suatu angka, Anda dapat menggunakan ikon naik dan turun desimal di bawah grup &#8220;Angka&#8221; pada pita. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-naik-turun-nilai-desimal-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-augmenter-diminuer-les-valeurs-decimales-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"increase-decrease-decimal-values\" width=\"305\" height=\"114\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Terapkan format nomor akuntansi menggunakan daftar drop-down grup nomor<\/h2><ol><li> Pertama, pilih sel atau rentang dengan angka yang ingin Anda format.<\/li><li> Setelah itu, buka tab \u201cBeranda\u201d, lalu klik panah tarik-turun di bawah grup \u201cNomor\u201d pada pita. <br><img loading=\"lazy\" decoding=\"async\" title=\"Daftar dropdown 5 nomor akuntansi 1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-numero-de-comptabilite-deroulant-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"accounting-number-drop-down\" width=\"771\" height=\"121\"><\/li><li> Sekarang, klik opsi \u201cAkuntansi\u201d dari daftar drop-down. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-pilih-akuntansi-opsi-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-selectionnez-loption-comptable-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-accounting-option\" width=\"563\" height=\"444\"><\/li><li> Pada titik ini, sel atau rentang yang dipilih diubah menjadi \u201cFormat Angka Akuntansi\u201d dengan menambahkan simbol mata uang, pemisah ribuan angka, dan dua tempat desimal ke nilai numerik. <br><img loading=\"lazy\" decoding=\"async\" title=\"Format 7-nilai-dikonversi-menjadi-angka-akuntansi-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-valeurs-converties-au-format-de-numero-comptable-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"values-converted-in-accounting-number-format\" width=\"203\" height=\"276\"><\/li><\/ol><p class=\"content-box-green\"> Seperti yang Anda lihat dalam metode ini, kami tidak memiliki kemungkinan untuk memilih format akuntansi dengan pilihan simbol mata uang.<\/p><p class=\"content-box-green\"> Oleh karena itu, format nomor akuntansi yang menggunakan opsi drop-down ini mungkin menampilkan simbol mata uang negara Anda, yang mungkin merupakan mata uang default sistem Anda.<\/p><h2 class=\"wp-block-heading\"> Terapkan format angka akuntansi menggunakan opsi Format Sel<\/h2><p> Dengan metode pemformatan angka akuntansi ini, pengguna dapat mengubah simbol mata uang default sistem Anda dan memilih simbol mata uang dari beberapa simbol mata uang berdasarkan mata uang negara yang berbeda.<\/p><ol><li> Pertama, pilih sel atau rentang dengan angka yang ingin Anda format, lalu klik kanan pilihan Anda.<\/li><li> Setelah itu, pilih opsi \u201cFormat Sel\u201d dari menu drop-down dan kotak dialog \u201cFormat Sel\u201d akan terbuka. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi-format-8-sel-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-cellules-de-format-option-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"format-cells-option\" width=\"340\" height=\"593\"><\/li><li> Sekarang, pilih tab \u201cNomor\u201d dan di bawah \u201cKategori\u201d pilih opsi \u201cAkuntansi\u201d.<\/li><li> Sekarang, klik panah tarik-turun \u201cSimbol\u201d dan gulir ke bawah melalui opsi mata uang dan pilih yang Anda inginkan.<\/li><li> Jika Anda ingin menambah atau mengurangi nilai desimal suatu angka, Anda dapat melakukan hal yang sama menggunakan panah atas dan bawah \u201cTempat Desimal\u201d.<\/li><li> Setelah selesai, klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"9-sel-format-diloag-box-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-cellules-format-diloag-box-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"format-cells-dialog-box\" width=\"494\" height=\"456\"><\/li><li> Pada titik ini, sel atau rentang yang dipilih diubah menjadi \u201cFormat Angka Akuntansi\u201d dengan menambahkan simbol mata uang yang baru saja Anda pilih dengan pemisah ribuan digit dan dua tempat desimal ke nilai numerik. <br><img loading=\"lazy\" decoding=\"async\" title=\"10-nilai-dalam-akuntansi-angka-simbol-format-1\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-valeurs-dans-le-symbole-de-format-de-numero-comptable-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"values-in-accounting-number-format-symbol\" width=\"212\" height=\"288\"><\/li><\/ol><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Microsoft Excel (Komponen, Bagian dan Catatan Pengetahuan)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-nomor-halaman\/\">Tambahkan nomor halaman di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/terapkan-gaya-koma\/\">Terapkan gaya koma di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tongkat\/\">Terapkan coretan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-sel-kosong\/\">Sorot sel kosong di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/simbol-pi\/\">Masukkan simbol PI (\u03c0) di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1847","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 mengatur format angka akuntansi di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menerapkan format angka akuntansi di Excel menggunakan tiga metode\" \/>\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-angka-akuntansi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara mengatur format angka akuntansi di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menerapkan format angka akuntansi di Excel menggunakan tiga metode\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:15:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/\",\"name\":\"Bagaimana cara mengatur format angka akuntansi di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png\",\"datePublished\":\"2023-10-31T16:41:03+00:00\",\"dateModified\":\"2023-12-06T06:15:56+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari berbagai cara menerapkan format angka akuntansi di Excel menggunakan tiga metode\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengatur format angka akuntansi di excel?\"}]},{\"@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 mengatur format angka akuntansi di Excel?","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menerapkan format angka akuntansi di Excel menggunakan tiga metode","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-angka-akuntansi\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara mengatur format angka akuntansi di Excel?","og_description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menerapkan format angka akuntansi di Excel menggunakan tiga metode","og_url":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:15:56+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/","url":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/","name":"Bagaimana cara mengatur format angka akuntansi di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png","datePublished":"2023-10-31T16:41:03+00:00","dateModified":"2023-12-06T06:15:56+00:00","description":"Dalam tutorial ini, Anda akan mempelajari berbagai cara menerapkan format angka akuntansi di Excel menggunakan tiga metode","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-comptabilite-vs-format-numerique-general-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/format-angka-akuntansi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengatur format angka akuntansi di excel?"}]},{"@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\/1847","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=1847"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1847\/revisions"}],"predecessor-version":[{"id":2471,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1847\/revisions\/2471"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1847"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}