Mas Hary,Coba cara ini: 1. format tanggal dirubah menjadi "yyyy-mm-dd"..apakah
proses export masih tidak sesuai dengan harapan?
2. buat kolom bantu dudate dengan memasukkan formula=TEXT(E5,"yyyy-mm-dd")
apakah juga setelah proses export datanya berubah?
Thanks,-zainul
#dikirim_pakai_mail.yahoo.com_tanpa_pulsa#
On Sunday, 3 February 2019, 6:41:16 AM GMT+7, harry budiman
sendtohar...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> 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
#yiv5195820083 #yiv5195820083 -- #yiv5195820083ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv5195820083
#yiv5195820083ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv5195820083
#yiv5195820083ygrp-mkp #yiv5195820083hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv5195820083 #yiv5195820083ygrp-mkp #yiv5195820083ads
{margin-bottom:10px;}#yiv5195820083 #yiv5195820083ygrp-mkp .yiv5195820083ad
{padding:0 0;}#yiv5195820083 #yiv5195820083ygrp-mkp .yiv5195820083ad p
{margin:0;}#yiv5195820083 #yiv5195820083ygrp-mkp .yiv5195820083ad a
{color:#0000ff;text-decoration:none;}#yiv5195820083 #yiv5195820083ygrp-sponsor
#yiv5195820083ygrp-lc {font-family:Arial;}#yiv5195820083
#yiv5195820083ygrp-sponsor #yiv5195820083ygrp-lc #yiv5195820083hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv5195820083
#yiv5195820083ygrp-sponsor #yiv5195820083ygrp-lc .yiv5195820083ad
{margin-bottom:10px;padding:0 0;}#yiv5195820083 #yiv5195820083actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv5195820083
#yiv5195820083activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv5195820083
#yiv5195820083activity span {font-weight:700;}#yiv5195820083
#yiv5195820083activity span:first-child
{text-transform:uppercase;}#yiv5195820083 #yiv5195820083activity span a
{color:#5085b6;text-decoration:none;}#yiv5195820083 #yiv5195820083activity span
span {color:#ff7900;}#yiv5195820083 #yiv5195820083activity span
.yiv5195820083underline {text-decoration:underline;}#yiv5195820083
.yiv5195820083attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv5195820083 .yiv5195820083attach div a
{text-decoration:none;}#yiv5195820083 .yiv5195820083attach img
{border:none;padding-right:5px;}#yiv5195820083 .yiv5195820083attach label
{display:block;margin-bottom:5px;}#yiv5195820083 .yiv5195820083attach label a
{text-decoration:none;}#yiv5195820083 blockquote {margin:0 0 0
4px;}#yiv5195820083 .yiv5195820083bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv5195820083
.yiv5195820083bold a {text-decoration:none;}#yiv5195820083 dd.yiv5195820083last
p a {font-family:Verdana;font-weight:700;}#yiv5195820083 dd.yiv5195820083last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv5195820083
dd.yiv5195820083last p span.yiv5195820083yshortcuts
{margin-right:0;}#yiv5195820083 div.yiv5195820083attach-table div div a
{text-decoration:none;}#yiv5195820083 div.yiv5195820083attach-table
{width:400px;}#yiv5195820083 div.yiv5195820083file-title a, #yiv5195820083
div.yiv5195820083file-title a:active, #yiv5195820083
div.yiv5195820083file-title a:hover, #yiv5195820083 div.yiv5195820083file-title
a:visited {text-decoration:none;}#yiv5195820083 div.yiv5195820083photo-title a,
#yiv5195820083 div.yiv5195820083photo-title a:active, #yiv5195820083
div.yiv5195820083photo-title a:hover, #yiv5195820083
div.yiv5195820083photo-title a:visited {text-decoration:none;}#yiv5195820083
div#yiv5195820083ygrp-mlmsg #yiv5195820083ygrp-msg p a
span.yiv5195820083yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv5195820083
.yiv5195820083green {color:#628c2a;}#yiv5195820083 .yiv5195820083MsoNormal
{margin:0 0 0 0;}#yiv5195820083 o {font-size:0;}#yiv5195820083
#yiv5195820083photos div {float:left;width:72px;}#yiv5195820083
#yiv5195820083photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv5195820083
#yiv5195820083photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv5195820083
#yiv5195820083reco-category {font-size:77%;}#yiv5195820083
#yiv5195820083reco-desc {font-size:77%;}#yiv5195820083 .yiv5195820083replbq
{margin:4px;}#yiv5195820083 #yiv5195820083ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv5195820083 #yiv5195820083ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv5195820083
#yiv5195820083ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv5195820083
#yiv5195820083ygrp-mlmsg select, #yiv5195820083 input, #yiv5195820083 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv5195820083
#yiv5195820083ygrp-mlmsg pre, #yiv5195820083 code {font:115%
monospace;}#yiv5195820083 #yiv5195820083ygrp-mlmsg *
{line-height:1.22em;}#yiv5195820083 #yiv5195820083ygrp-mlmsg #yiv5195820083logo
{padding-bottom:10px;}#yiv5195820083 #yiv5195820083ygrp-msg p a
{font-family:Verdana;}#yiv5195820083 #yiv5195820083ygrp-msg
p#yiv5195820083attach-count span {color:#1E66AE;font-weight:700;}#yiv5195820083
#yiv5195820083ygrp-reco #yiv5195820083reco-head
{color:#ff7900;font-weight:700;}#yiv5195820083 #yiv5195820083ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv5195820083 #yiv5195820083ygrp-sponsor
#yiv5195820083ov li a {font-size:130%;text-decoration:none;}#yiv5195820083
#yiv5195820083ygrp-sponsor #yiv5195820083ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv5195820083
#yiv5195820083ygrp-sponsor #yiv5195820083ov ul {margin:0;padding:0 0 0
8px;}#yiv5195820083 #yiv5195820083ygrp-text
{font-family:Georgia;}#yiv5195820083 #yiv5195820083ygrp-text p {margin:0 0 1em
0;}#yiv5195820083 #yiv5195820083ygrp-text tt {font-size:120%;}#yiv5195820083
#yiv5195820083ygrp-vital ul li:last-child {border-right:none
!important;}#yiv5195820083
