{"id":1822,"date":"2023-11-02T03:40:46","date_gmt":"2023-11-02T03:40:46","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/"},"modified":"2023-12-06T06:18:22","modified_gmt":"2023-12-06T06:18:22","slug":"ubah-tanggal-menjadi-angka","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/","title":{"rendered":"Bagaimana cara mengubah tanggal menjadi angka di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2849752273\"><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 menyimpan tanggal sebagai angka. Setiap tanggal mempunyai nilai nomor seri yang unik. Jika Anda melihat pada contoh berikut, Anda memiliki tanggal di sel A1 &#8220;1-Jan-2022&#8221;. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64897\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"tanggal-di-bilah rumus\" width=\"355\" height=\"222\"><\/figure><\/div><p> Namun jika dilihat pada formula bar, yang ditampilkan adalah tanggal, bukan nomor seri. Jadi, dalam tutorial ini, Anda akan mempelajari cara mengubah tanggal menjadi nomor seri. <\/p><div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/convertir-la-date-en-nombre-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><h2 class=\"wp-block-heading\"> Ubah tanggal menjadi angka<\/h2><p> Seperti yang saya katakan di awal, Excel menyimpan tanggal sebagai nomor seri, dan Anda dapat mengonversi tanggal menjadi nomor seri hanya dengan mengubah formatnya. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64898\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-convertir-la-date-en-nombre-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"konversi-tanggal-ke-angka\" width=\"595\" height=\"473\"><\/figure><\/div><ol><li> Pertama, pilih sel tempat Anda ingin mengubah tanggal menjadi angka.<\/li><li> Selanjutnya, buka pemformatan khusus menggunakan <a href=\"https:\/\/exceladvisor.org\/id\/buka-opsi-format-sel\/\">pintasan keyboard Ctrl + 1<\/a> .<\/li><li> Sekarang, di opsi kategori, pilih format angka.<\/li><li> Terakhir, tentukan tempat desimal sebagai nol dan klik OK.<\/li><\/ol><p> Setelah Anda mengubah format, Anda akan mendapatkan nomor sebagai berikut, di mana Anda memiliki nomor, bukan tanggal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64899\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-date-comme-numero-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"tanggal-sebagai-angka\" width=\"381\" height=\"237\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Ubah tanggal teks menjadi angka<\/h2><p> Mungkin saja Anda memiliki tanggal di sel yang disimpan sebagai teks dan sekarang Anda ingin mengubahnya menjadi angka. Dalam hal ini Anda perlu menggunakan DATEVALUE yang mengubah tanggal menjadi serangkaian tanggal. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64900\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-texter-la-date-dans-le-numero-2.png\" sizes=\"auto, \" srcset=\"\" alt=\"teks-tanggal-sebagai-angka\" width=\"402\" height=\"264\"><\/figure><\/div><ol type=\"1\"><li> Masukkan \u201c=DATEVALUE\u201d di dalam sel.<\/li><li> Kemudian masukkan tanda kurung awal.<\/li><li> Lihat sel di mana Anda memiliki tanggalnya.<\/li><li> Sekarang masukkan tanda kurung penutup dan tekan Enter. <\/li><\/ol><div class=\"gb-container gb-container-d3fcd064 gb-container-sample-file\"><h2 class=\"gb-headline gb-headline-025a630b gb-headline-text gb-headline-4f7959c2\"> Dapatkan file Excelnya<\/h2> <a class=\"gb-button gb-button-be33d2c2 gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/convertir-la-date-en-nombre-2.xlsx\" rel=\"nofollow\">Unduh<\/a><\/div><div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/rumus\/\">Daftar rumus Excel<\/a><h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> Rumus terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-50d07e0d\"><div class=\"gb-container gb-container-50d07e0d\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/membandingkan-dua-tanggal\/\">Bandingkan dua tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/teks-sampai-saat-ini\/\">Ubah teks menjadi tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/rentang-tanggal\/\">Buat rentang tanggal di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/format-tanggal-khusus\/\">Format tanggal khusus di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tanggal-jika\/\">Fungsi DATEDIF di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-5b4a0cf9\"><div class=\"gb-container gb-container-5b4a0cf9\"><\/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-1822","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>\u25b7 Bagaimana cara mengubah tanggal menjadi angka di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara mengubah tanggal menjadi angka. Excel menyimpan tanggal sebagai nomor seri dan Anda\" \/>\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\/ubah-tanggal-menjadi-angka\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengubah tanggal menjadi angka di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara mengubah tanggal menjadi angka. Excel menyimpan tanggal sebagai nomor seri dan Anda\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/\",\"name\":\"\u25b7 Bagaimana cara mengubah tanggal menjadi angka di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.png\",\"datePublished\":\"2023-11-02T03:40:46+00:00\",\"dateModified\":\"2023-12-06T06:18:22+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara mengubah tanggal menjadi angka. Excel menyimpan tanggal sebagai nomor seri dan Anda\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah tanggal menjadi angka 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":"\u25b7 Bagaimana cara mengubah tanggal menjadi angka di Excel?","description":"Dalam tutorial ini, kita akan mempelajari cara mengubah tanggal menjadi angka. Excel menyimpan tanggal sebagai nomor seri dan Anda","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\/ubah-tanggal-menjadi-angka\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengubah tanggal menjadi angka di Excel?","og_description":"Dalam tutorial ini, kita akan mempelajari cara mengubah tanggal menjadi angka. Excel menyimpan tanggal sebagai nomor seri dan Anda","og_url":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.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\/ubah-tanggal-menjadi-angka\/","url":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/","name":"\u25b7 Bagaimana cara mengubah tanggal menjadi angka di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.png","datePublished":"2023-11-02T03:40:46+00:00","dateModified":"2023-12-06T06:18:22+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara mengubah tanggal menjadi angka. Excel menyimpan tanggal sebagai nomor seri dan Anda","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-date-dans-la-barre-de-formule-2.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/ubah-tanggal-menjadi-angka\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah tanggal menjadi angka 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\/1822","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=1822"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1822\/revisions"}],"predecessor-version":[{"id":2716,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1822\/revisions\/2716"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}