[belajar-excel] Merubah Format Tanggal hasil export default dari system [1 Attachment]

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] Merubah Format Tanggal hasil export default dari system [1 Attachment]

harbud
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



contoh kasus.xlsx (14K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Merubah Format Tanggal hasil export default dari system

hendrik karnadi
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 [hidden email] [belajar-excel]<[hidden email]> 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  
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Merubah Format Tanggal hasil export default dari system

zainul_ulum[at]yahoo[dot]com
In reply to this post by harbud
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 [hidden email] [belajar-excel] <[hidden email]> 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  
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Merubah Format Tanggal hasil export default dari system

Kid
Administrator
Coba juga, blok data tgl hasil sistem, gunakan text to column, pilih delimited (pilih saja tab atau comma), next pilih kolom tanggal itu, tipe set jadi date, pilih dmy, tekan next sampai finish.

Jika hasil sistem berupa text file (.txt atau .csv atau apa saja), di windows explorer open with excel, muncul tampilan seperti fitur text to column. Pilih delimiter sesuai file hasil sistem, next, klik kolom tanggal, pilih tipe date, pilih dmy, next sampai finish.

Regards,
Kid
Sent from my smart enough phone

> On Feb 3, 2019, at 09:41, Zainul Ulum [hidden email] [belajar-excel] <[hidden email]> wrote:
>
> 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 [hidden email] [belajar-excel] <[hidden email]> 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
>
>  
>
>  
>
>