{"id":3176,"date":"2024-05-23T11:26:11","date_gmt":"2024-05-23T04:26:11","guid":{"rendered":"https:\/\/infomadrasah.net\/?p=3176"},"modified":"2025-05-23T11:30:13","modified_gmt":"2025-05-23T04:30:13","slug":"numeric-mail-merge","status":"publish","type":"post","link":"https:\/\/infomadrasah.net\/?p=3176","title":{"rendered":"Numeric Mail Merge"},"content":{"rendered":"<div>Beberapa hari lalu ketika melakukan <i>MailMerge<\/i> dari data nilai hasil US dan UN (Ujian Sekolah dan Ujian Nasional) kedalam format SKHUN Sementara terjadi &#8220;kekacauan&#8221; pada nilai-nilai siswa yang seharusnya berbentuk angka desimal dengan 2 digit di belakang koma malah jadi 16 digit. Mau tahu?<\/div>\n<div>Jika sobat mendapati masalah serupa seperti nampak pada gambar berikut:<\/div>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgBSPaUOxO7cM9HFl6dSucBTzShVvBlzyDAQ-U2-G-qGv0yr8g4olI8j4eq2Rcp8Bk2j7GLKonOJNXlT09dx4bjmw_9Jr20MPwmFJlH3wR3CU-mc-_s1pa5ihLDSa5UAnj88a7y2YCDwSQ\/s1600\/MailMerge-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgBSPaUOxO7cM9HFl6dSucBTzShVvBlzyDAQ-U2-G-qGv0yr8g4olI8j4eq2Rcp8Bk2j7GLKonOJNXlT09dx4bjmw_9Jr20MPwmFJlH3wR3CU-mc-_s1pa5ihLDSa5UAnj88a7y2YCDwSQ\/s320\/MailMerge-1.jpg\" width=\"320\" height=\"192\" border=\"0\" \/><\/a><\/div>\n<div>Langkah-langkah untuk mengatasinya adalah:<\/div>\n<div class=\"separator\"><\/div>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEi1oDe9rv_3ImWwpO45rFqK3XVSUK9oOvn1FJ44rnwtj3vzmD3NxEOtGgOlmErpzL_vlrl1tDXw65IltxpeCTsghZMKtu6BmyCwGcCpiMp0_kYtJexnea-4iUtjQvyeBFp1QIxWzN07SIs\/s1600\/MailMerge-6.jpg\"><img decoding=\"async\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEi1oDe9rv_3ImWwpO45rFqK3XVSUK9oOvn1FJ44rnwtj3vzmD3NxEOtGgOlmErpzL_vlrl1tDXw65IltxpeCTsghZMKtu6BmyCwGcCpiMp0_kYtJexnea-4iUtjQvyeBFp1QIxWzN07SIs\/s1600\/MailMerge-6.jpg\" border=\"0\" \/><\/a><\/div>\n<ul>\n<li>\n<div>Klik pada bagian angka-angka yang ingin dibuat desimal sehingga membentuk blok, lalu klik kanan <i>mouse<\/i> dan pilih <b>Edit Field<\/b>:<\/p>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhdrkPYQWC8x0O0MbSBgGoA6L0ceYjbaDSm21U-qUU8a-_esd36riV9BsflBEeX9UBpQGkbmcV3fxzELqsifKlag4X9bgrueqxx2w6u5YoshRzdLI0AwQWjnXKIeI5-Bvi1n1fXjbHmFtw\/s1600\/MailMerge-2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhdrkPYQWC8x0O0MbSBgGoA6L0ceYjbaDSm21U-qUU8a-_esd36riV9BsflBEeX9UBpQGkbmcV3fxzELqsifKlag4X9bgrueqxx2w6u5YoshRzdLI0AwQWjnXKIeI5-Bvi1n1fXjbHmFtw\/s320\/MailMerge-2.jpg\" width=\"320\" height=\"190\" border=\"0\" \/><\/a><\/div>\n<\/div>\n<\/li>\n<li>Setelah muncul kotak dialog, klik <b>Field Codes<\/b>, yang terletak di pojok kiri bawah, sehingga muncul <b>Advance Field Properties<\/b>, seperti ini:<br \/>\n<span id=\"goog_1758129471\"><\/span><span id=\"goog_1758129472\"><\/span><span id=\"goog_1758129476\"><\/span><span id=\"goog_1758129477\"><\/span>Agama adalah nama <i>Field<\/i> untuk Nilai Pendidikan Agama<\/p>\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhRuGiHDoSxxTTtP6mYg-Z4Cd7R2cA9I01u0_pEm-BQzKuIGdtNRvakkAyaBGk5NloS5-nrZi8UaZn2xotRQJFLlPrvXhNp8KwqWBIG4XpXBH1cMNWRHc_h__SWYBPUzfbGh0P-mBeWUs4\/s1600\/MailMerge-4.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEhRuGiHDoSxxTTtP6mYg-Z4Cd7R2cA9I01u0_pEm-BQzKuIGdtNRvakkAyaBGk5NloS5-nrZi8UaZn2xotRQJFLlPrvXhNp8KwqWBIG4XpXBH1cMNWRHc_h__SWYBPUzfbGh0P-mBeWUs4\/s320\/MailMerge-4.jpg\" width=\"320\" height=\"72\" border=\"0\" \/><\/a><\/div>\n<\/li>\n<li>Untuk menjadikan desimal dengan 2 digit dibelakang koma, tambahkan kode <b>\\# &#8220;0,00&#8221;<\/b>, seperti ini:<br \/>\n<blockquote>\n<div class=\"notes\">\n<div class=\"separator\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgkEaynthjYAkMM3iSMUw3zFG_zdyYOgeEEtnkDPZT_SVCSHF-g78nrBngHl4ltQG5i2j9M-8-AcW6oNk9T-vZ4bCWPqQXyvKhSOoZwMCe8Ko2L6jv78SK3rXqZ6ZOcB4vL1SGdYlfpZKA\/s1600\/MailMerge-5.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgkEaynthjYAkMM3iSMUw3zFG_zdyYOgeEEtnkDPZT_SVCSHF-g78nrBngHl4ltQG5i2j9M-8-AcW6oNk9T-vZ4bCWPqQXyvKhSOoZwMCe8Ko2L6jv78SK3rXqZ6ZOcB4vL1SGdYlfpZKA\/s320\/MailMerge-5.jpg\" width=\"320\" height=\"72\" border=\"0\" \/><\/a><\/div>\n<\/div>\n<p>Catatan :<\/p><\/blockquote>\n<\/li>\n<li>Setingan Regional and Languange Options pada Control Panel diset ke Indonesia.<\/li>\n<li>Lakukan proses <i>edit field<\/i> tersebut pada semua <i>field<\/i> yang ingin diubah.<\/li>\n<li>Setelah itu klik OK, maka hasilnya akan seperti ini:<\/li>\n<\/ul>\n<p><a href=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgqR7gzbe_p7uA9AcLsu-huLSjXiE8PMhj6_gVlOAZ8tJx37kwjUNBuc4Mt87V1BwCPfdPWO2oP9Sb91mKQvH6JOjgS_DdzdPXtVWaYz7sKFJVXOQWwc30dynS2qs8ss3ZCxmxHKKHFh-I\/s1600\/MailMerge-6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/blogger.googleusercontent.com\/img\/b\/R29vZ2xl\/AVvXsEgqR7gzbe_p7uA9AcLsu-huLSjXiE8PMhj6_gVlOAZ8tJx37kwjUNBuc4Mt87V1BwCPfdPWO2oP9Sb91mKQvH6JOjgS_DdzdPXtVWaYz7sKFJVXOQWwc30dynS2qs8ss3ZCxmxHKKHFh-I\/s320\/MailMerge-6.jpg\" width=\"320\" height=\"180\" border=\"0\" \/><\/a><\/p>\n<div>Lalu bagaimana untuk mengatasi masalah penanggalan atau uang pada <i>MailMerge<\/i> Word 2007? Caranya sama saja dengan cara di atas hanya penambahan kode pada <i>field codes<\/i>-nya saja berbeda:<\/div>\n<ul>\n<li>Untuk tanggal, tambahkan kode: <b>\\@ &#8220;dd MMMM yyyy&#8221;<\/b><\/li>\n<li>Untuk uang, tambahkan kode: <b>\\# &#8220;#.##0,00&#8221;<\/b><\/li>\n<\/ul>\n<div>OK bro, segitu tutorialnya. Semoga bermanfaat&#8230;<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Beberapa hari lalu ketika melakukan MailMerge dari data nilai hasil US dan <a class=\"read-more\" href=\"https:\/\/infomadrasah.net\/?p=3176\" title=\"Numeric Mail Merge\" itemprop=\"url\"><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"newstopic":[],"class_list":["post-3176","post","type-post","status-publish","format-standard","category-berita"],"_links":{"self":[{"href":"https:\/\/infomadrasah.net\/index.php?rest_route=\/wp\/v2\/posts\/3176","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infomadrasah.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infomadrasah.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/infomadrasah.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/infomadrasah.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3176"}],"version-history":[{"count":1,"href":"https:\/\/infomadrasah.net\/index.php?rest_route=\/wp\/v2\/posts\/3176\/revisions"}],"predecessor-version":[{"id":3177,"href":"https:\/\/infomadrasah.net\/index.php?rest_route=\/wp\/v2\/posts\/3176\/revisions\/3177"}],"wp:attachment":[{"href":"https:\/\/infomadrasah.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infomadrasah.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infomadrasah.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3176"},{"taxonomy":"newstopic","embeddable":true,"href":"https:\/\/infomadrasah.net\/index.php?rest_route=%2Fwp%2Fv2%2Fnewstopic&post=3176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}