{"id":3689,"date":"2023-07-16T03:06:38","date_gmt":"2023-07-16T03:06:38","guid":{"rendered":"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/"},"modified":"2023-07-16T03:06:38","modified_gmt":"2023-07-16T03:06:38","slug":"google-sheet-menambahkan-koma-ke-nomor","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/","title":{"rendered":"Google spreadsheet: cara menambahkan koma ke angka"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk menambahkan koma ke angka di Google Sheets adalah dengan menggunakan opsi <strong>Number<\/strong> pada tab <strong>Format<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara menggunakan opsi ini untuk menambahkan koma ke nomor di Google Spreadsheet.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan datanya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Pertama, masukkan kumpulan data berikut ke Google Spreadsheet yang menunjukkan jumlah total penjualan yang dilakukan oleh berbagai karyawan suatu perusahaan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30153 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule1.jpg\" alt=\"\" width=\"484\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Langkah 2: Tambahkan Koma ke Angka<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Selanjutnya, sorot rentang sel <strong>B2:B12<\/strong> :<\/span><\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30154 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule2.jpg\" alt=\"\" width=\"485\" height=\"448\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, klik tab <strong>Format<\/strong> , lalu <strong>Number<\/strong> , lalu Number:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-30155\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule3.jpg\" alt=\"Google Spreadsheet menambahkan koma ke nomor\" width=\"642\" height=\"531\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Koma otomatis akan ditambahkan pada nilai di kolom <strong>Penjualan<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30156 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule4.jpg\" alt=\"\" width=\"485\" height=\"474\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa pada tab <strong>Angka<\/strong> , Anda juga dapat menentukan bahwa Anda ingin nilai diformat sebagai mata uang dengan koma:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30157 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule5.jpg\" alt=\"\" width=\"541\" height=\"525\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Ini akan menambahkan tanda dolar di depan setiap nilai dan memaksa dua tempat desimal ditampilkan untuk setiap nilai:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-30158 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule6.jpg\" alt=\"\" width=\"490\" height=\"492\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa setiap nilai di kolom <strong>Penjualan<\/strong> kini ditampilkan dalam format mata uang.<\/span><\/p>\n<h2> <strong><span style=\"color: #000000;\">Sumber daya tambahan<\/span><\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/sumif-berisi-lembar-google\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIF yang terdapat di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/sumif-atau-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan SUMIF dengan OR di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-hanya-menjumlahkan-angka-positif\/\" target=\"_blank\" rel=\"noopener\">Cara Menambahkan Angka Positif Saja di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk menambahkan koma ke angka di Google Sheets adalah dengan menggunakan opsi Number pada tab Format . Contoh langkah demi langkah berikut menunjukkan cara menggunakan opsi ini untuk menambahkan koma ke nomor di Google Spreadsheet. Langkah 1: Masukkan datanya Pertama, masukkan kumpulan data berikut ke Google Spreadsheet yang menunjukkan jumlah total penjualan yang [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Spreadsheet: Cara Menambahkan Koma ke Angka - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambahkan koma pada angka di Google Sheets, beserta sebuah 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:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara Menambahkan Koma ke Angka - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambahkan koma pada angka di Google Sheets, beserta sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T03:06:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/\",\"url\":\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/\",\"name\":\"Google Spreadsheet: Cara Menambahkan Koma ke Angka - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T03:06:38+00:00\",\"dateModified\":\"2023-07-16T03:06:38+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambahkan koma pada angka di Google Sheets, beserta sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google spreadsheet: cara menambahkan koma ke angka\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Spreadsheet: Cara Menambahkan Koma ke Angka - Statologi","description":"Tutorial ini menjelaskan cara menambahkan koma pada angka di Google Sheets, beserta sebuah 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:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara Menambahkan Koma ke Angka - Statologi","og_description":"Tutorial ini menjelaskan cara menambahkan koma pada angka di Google Sheets, beserta sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/","og_site_name":"Statorials","article_published_time":"2023-07-16T03:06:38+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/virgule1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/","url":"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/","name":"Google Spreadsheet: Cara Menambahkan Koma ke Angka - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T03:06:38+00:00","dateModified":"2023-07-16T03:06:38+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambahkan koma pada angka di Google Sheets, beserta sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/google-sheet-menambahkan-koma-ke-nomor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google spreadsheet: cara menambahkan koma ke angka"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3689"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3689"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3689\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}