[belajar-excel] Tanggal yang tidak bisa diformat

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

[belajar-excel] Tanggal yang tidak bisa diformat

go tjwan ham
Dear All,

 Mohon bantuannya untuk tanggal yang tidak bisa diformat. Mohon penjelasannya.
Contoh: 03/09/1959 menjadi 03 Sep 1959


File terlampir
 
 Sent from Yahoo Mail on Android https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature


Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Tanggal yang tidak bisa diformat

Kid
Administrator
Data bertipe text tidak bisa di format number (format cells -> tab Number)
Jadi, data tanggal (yang tampak berisi tanggal itu) milik Anda tersebut
adalah bertipe Text, sehingga tidak bisa di format number.
Coba ubah cara input data tanggal dengan format pengisian YYYY-MM-DD agar
pasti ter-input sebagai data tanggal bertipe datetime atau number serial
date supaya bisa di-format number.

Regards,
Kid





On Thu, Jan 3, 2019 at 6:42 AM go tjwan ham [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> Dear All,
>
> Mohon bantuannya untuk tanggal yang tidak bisa diformat. Mohon
> penjelasannya.
> Contoh: 03/09/1959 menjadi 03 Sep 1959
>
>
> File terlampir
>
> Sent from Yahoo Mail on Android
> <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] Tanggal yang tidak bisa diformat

go tjwan ham
Thanks Mr.Kid

Regards,Ham

Sent from Yahoo Mail on Android

  On Thu, Jan 3, 2019 at 14:13, 'Mr. Kid' [hidden email] [belajar-excel]<[hidden email]> wrote:    

Data bertipe text tidak bisa di format number (format cells -> tab Number)Jadi, data tanggal (yang tampak berisi tanggal itu) milik Anda tersebut adalah bertipe Text, sehingga tidak bisa di format number.Coba ubah cara input data tanggal dengan format pengisian YYYY-MM-DD agar pasti ter-input sebagai data tanggal bertipe datetime atau number serial date supaya bisa di-format number.
Regards,Kid




On Thu, Jan 3, 2019 at 6:42 AM go tjwan ham [hidden email] [belajar-excel] <[hidden email]> wrote:

  

Dear All,
Mohon bantuannya untuk tanggal yang tidak bisa diformat. Mohon penjelasannya.
Contoh: 03/09/1959 menjadi 03 Sep 1959


File terlampir
Sent from Yahoo Mail on Android


  #yiv3468662483 #yiv3468662483 -- #yiv3468662483ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3468662483 #yiv3468662483ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3468662483 #yiv3468662483ygrp-mkp #yiv3468662483hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3468662483 #yiv3468662483ygrp-mkp #yiv3468662483ads {margin-bottom:10px;}#yiv3468662483 #yiv3468662483ygrp-mkp .yiv3468662483ad {padding:0 0;}#yiv3468662483 #yiv3468662483ygrp-mkp ...yiv3468662483ad p {margin:0;}#yiv3468662483 #yiv3468662483ygrp-mkp .yiv3468662483ad a {color:#0000ff;text-decoration:none;}#yiv3468662483 #yiv3468662483ygrp-sponsor #yiv3468662483ygrp-lc {font-family:Arial;}#yiv3468662483 #yiv3468662483ygrp-sponsor #yiv3468662483ygrp-lc #yiv3468662483hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3468662483 #yiv3468662483ygrp-sponsor #yiv3468662483ygrp-lc .yiv3468662483ad {margin-bottom:10px;padding:0 0;}#yiv3468662483 #yiv3468662483actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3468662483 #yiv3468662483activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3468662483 #yiv3468662483activity span {font-weight:700;}#yiv3468662483 #yiv3468662483activity span:first-child {text-transform:uppercase;}#yiv3468662483 #yiv3468662483activity span a {color:#5085b6;text-decoration:none;}#yiv3468662483 #yiv3468662483activity span span {color:#ff7900;}#yiv3468662483 #yiv3468662483activity span .yiv3468662483underline {text-decoration:underline;}#yiv3468662483 .yiv3468662483attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3468662483 .yiv3468662483attach div a {text-decoration:none;}#yiv3468662483 .yiv3468662483attach img {border:none;padding-right:5px;}#yiv3468662483 .yiv3468662483attach label {display:block;margin-bottom:5px;}#yiv3468662483 .yiv3468662483attach label a {text-decoration:none;}#yiv3468662483 blockquote {margin:0 0 0 4px;}#yiv3468662483 .yiv3468662483bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3468662483 .yiv3468662483bold a {text-decoration:none;}#yiv3468662483 dd.yiv3468662483last p a {font-family:Verdana;font-weight:700;}#yiv3468662483 dd.yiv3468662483last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3468662483 dd.yiv3468662483last p span.yiv3468662483yshortcuts {margin-right:0;}#yiv3468662483 div.yiv3468662483attach-table div div a {text-decoration:none;}#yiv3468662483 div.yiv3468662483attach-table {width:400px;}#yiv3468662483 div.yiv3468662483file-title a, #yiv3468662483 div.yiv3468662483file-title a:active, #yiv3468662483 div.yiv3468662483file-title a:hover, #yiv3468662483 div.yiv3468662483file-title a:visited {text-decoration:none;}#yiv3468662483 div.yiv3468662483photo-title a, #yiv3468662483 div.yiv3468662483photo-title a:active, #yiv3468662483 div.yiv3468662483photo-title a:hover, #yiv3468662483 div.yiv3468662483photo-title a:visited {text-decoration:none;}#yiv3468662483 div#yiv3468662483ygrp-mlmsg #yiv3468662483ygrp-msg p a span.yiv3468662483yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3468662483 .yiv3468662483green {color:#628c2a;}#yiv3468662483 .yiv3468662483MsoNormal {margin:0 0 0 0;}#yiv3468662483 o {font-size:0;}#yiv3468662483 #yiv3468662483photos div {float:left;width:72px;}#yiv3468662483 #yiv3468662483photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3468662483 #yiv3468662483photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3468662483 #yiv3468662483reco-category {font-size:77%;}#yiv3468662483 #yiv3468662483reco-desc {font-size:77%;}#yiv3468662483 .yiv3468662483replbq {margin:4px;}#yiv3468662483 #yiv3468662483ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3468662483 #yiv3468662483ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3468662483 #yiv3468662483ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3468662483 #yiv3468662483ygrp-mlmsg select, #yiv3468662483 input, #yiv3468662483 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3468662483 #yiv3468662483ygrp-mlmsg pre, #yiv3468662483 code {font:115% monospace;}#yiv3468662483 #yiv3468662483ygrp-mlmsg * {line-height:1.22em;}#yiv3468662483 #yiv3468662483ygrp-mlmsg #yiv3468662483logo {padding-bottom:10px;}#yiv3468662483 #yiv3468662483ygrp-msg p a {font-family:Verdana;}#yiv3468662483 #yiv3468662483ygrp-msg p#yiv3468662483attach-count span {color:#1E66AE;font-weight:700;}#yiv3468662483 #yiv3468662483ygrp-reco #yiv3468662483reco-head {color:#ff7900;font-weight:700;}#yiv3468662483 #yiv3468662483ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3468662483 #yiv3468662483ygrp-sponsor #yiv3468662483ov li a {font-size:130%;text-decoration:none;}#yiv3468662483 #yiv3468662483ygrp-sponsor #yiv3468662483ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3468662483 #yiv3468662483ygrp-sponsor #yiv3468662483ov ul {margin:0;padding:0 0 0 8px;}#yiv3468662483 #yiv3468662483ygrp-text {font-family:Georgia;}#yiv3468662483 #yiv3468662483ygrp-text p {margin:0 0 1em 0;}#yiv3468662483 #yiv3468662483ygrp-text tt {font-size:120%;}#yiv3468662483 #yiv3468662483ygrp-vital ul li:last-child {border-right:none !important;}#yiv3468662483