Hai Harry,Coba ubah format tanggal di komputer anda menjadi Indonesian. Salam,HK
Sent from Yahoo Mail on Android On Sun, Feb 3, 2019 at 6:41, harry budiman [email protected] [belajar-excel]<[email protected]> wrote: Selamat malam bapak ibu yang baik Ada kasus dimana hasil export dari system selalu membentuk tanggal yang formatnya tidak sesuai harapan Dapatkah dibantu bagaimana agar format date tsb dapat dirubah sesuai dengan keingian Contoh kasus saya lampirkan Terima kasih atas bantuannya Salam harr #yiv1646760565 #yiv1646760565 -- #yiv1646760565ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1646760565 #yiv1646760565ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1646760565 #yiv1646760565ygrp-mkp #yiv1646760565hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1646760565 #yiv1646760565ygrp-mkp #yiv1646760565ads {margin-bottom:10px;}#yiv1646760565 #yiv1646760565ygrp-mkp .yiv1646760565ad {padding:0 0;}#yiv1646760565 #yiv1646760565ygrp-mkp .yiv1646760565ad p {margin:0;}#yiv1646760565 #yiv1646760565ygrp-mkp .yiv1646760565ad a {color:#0000ff;text-decoration:none;}#yiv1646760565 #yiv1646760565ygrp-sponsor #yiv1646760565ygrp-lc {font-family:Arial;}#yiv1646760565 #yiv1646760565ygrp-sponsor #yiv1646760565ygrp-lc #yiv1646760565hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1646760565 #yiv1646760565ygrp-sponsor #yiv1646760565ygrp-lc .yiv1646760565ad {margin-bottom:10px;padding:0 0;}#yiv1646760565 #yiv1646760565actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1646760565 #yiv1646760565activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1646760565 #yiv1646760565activity span {font-weight:700;}#yiv1646760565 #yiv1646760565activity span:first-child {text-transform:uppercase;}#yiv1646760565 #yiv1646760565activity span a {color:#5085b6;text-decoration:none;}#yiv1646760565 #yiv1646760565activity span span {color:#ff7900;}#yiv1646760565 #yiv1646760565activity span .yiv1646760565underline {text-decoration:underline;}#yiv1646760565 .yiv1646760565attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1646760565 .yiv1646760565attach div a {text-decoration:none;}#yiv1646760565 .yiv1646760565attach img {border:none;padding-right:5px;}#yiv1646760565 .yiv1646760565attach label {display:block;margin-bottom:5px;}#yiv1646760565 .yiv1646760565attach label a {text-decoration:none;}#yiv1646760565 blockquote {margin:0 0 0 4px;}#yiv1646760565 .yiv1646760565bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1646760565 .yiv1646760565bold a {text-decoration:none;}#yiv1646760565 dd.yiv1646760565last p a {font-family:Verdana;font-weight:700;}#yiv1646760565 dd.yiv1646760565last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1646760565 dd.yiv1646760565last p span.yiv1646760565yshortcuts {margin-right:0;}#yiv1646760565 div.yiv1646760565attach-table div div a {text-decoration:none;}#yiv1646760565 div.yiv1646760565attach-table {width:400px;}#yiv1646760565 div.yiv1646760565file-title a, #yiv1646760565 div.yiv1646760565file-title a:active, #yiv1646760565 div.yiv1646760565file-title a:hover, #yiv1646760565 div.yiv1646760565file-title a:visited {text-decoration:none;}#yiv1646760565 div.yiv1646760565photo-title a, #yiv1646760565 div.yiv1646760565photo-title a:active, #yiv1646760565 div.yiv1646760565photo-title a:hover, #yiv1646760565 div.yiv1646760565photo-title a:visited {text-decoration:none;}#yiv1646760565 div#yiv1646760565ygrp-mlmsg #yiv1646760565ygrp-msg p a span.yiv1646760565yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1646760565 .yiv1646760565green {color:#628c2a;}#yiv1646760565 .yiv1646760565MsoNormal {margin:0 0 0 0;}#yiv1646760565 o {font-size:0;}#yiv1646760565 #yiv1646760565photos div {float:left;width:72px;}#yiv1646760565 #yiv1646760565photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1646760565 #yiv1646760565photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1646760565 #yiv1646760565reco-category {font-size:77%;}#yiv1646760565 #yiv1646760565reco-desc {font-size:77%;}#yiv1646760565 .yiv1646760565replbq {margin:4px;}#yiv1646760565 #yiv1646760565ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1646760565 #yiv1646760565ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1646760565 #yiv1646760565ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1646760565 #yiv1646760565ygrp-mlmsg select, #yiv1646760565 input, #yiv1646760565 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1646760565 #yiv1646760565ygrp-mlmsg pre, #yiv1646760565 code {font:115% monospace;}#yiv1646760565 #yiv1646760565ygrp-mlmsg * {line-height:1.22em;}#yiv1646760565 #yiv1646760565ygrp-mlmsg #yiv1646760565logo {padding-bottom:10px;}#yiv1646760565 #yiv1646760565ygrp-msg p a {font-family:Verdana;}#yiv1646760565 #yiv1646760565ygrp-msg p#yiv1646760565attach-count span {color:#1E66AE;font-weight:700;}#yiv1646760565 #yiv1646760565ygrp-reco #yiv1646760565reco-head {color:#ff7900;font-weight:700;}#yiv1646760565 #yiv1646760565ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1646760565 #yiv1646760565ygrp-sponsor #yiv1646760565ov li a {font-size:130%;text-decoration:none;}#yiv1646760565 #yiv1646760565ygrp-sponsor #yiv1646760565ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1646760565 #yiv1646760565ygrp-sponsor #yiv1646760565ov ul {margin:0;padding:0 0 0 8px;}#yiv1646760565 #yiv1646760565ygrp-text {font-family:Georgia;}#yiv1646760565 #yiv1646760565ygrp-text p {margin:0 0 1em 0;}#yiv1646760565 #yiv1646760565ygrp-text tt {font-size:120%;}#yiv1646760565 #yiv1646760565ygrp-vital ul li:last-child {border-right:none !important;}#yiv1646760565
