RE: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal terus ya??? [help dunk] [1 Attachment]

Mon, 12 Oct 2015 04:32:31 -0700 

trims respon cepetnya Om Reza, tapi seperti dilampiran sy sheet2 itu muncul 
respon error dari excelnya, naah itu dia sy ga tau kenapa....


ini sy lampirin lagi plus pesan errornya
--------------------------------------------
Pada Sen, 12/10/15, SUYONO [email protected] [belajar-excel] 
<[email protected]> menulis:


 Judul: RE: [belajar-excel] ask: gabung data teks dgn tanggal, kenapa gagal 
terus ya??? [help dunk]
 Kepada: "[email protected]" <[email protected]>
 Tanggal: Senin, 12 Oktober, 2015, 5:45 PM


  









      







 Coba pake
 formula:

   

 =A1&"
 "&TEXT(B1,"DD/MM/YY")

   





 From:
 [email protected]
 [mailto:[email protected]]

 Sent: Monday, October 12, 2015 4:59 PM

 To: [email protected]

 Subject: [belajar-excel] ask: gabung data teks dgn
 tanggal, kenapa gagal
 terus ya??? [help dunk] [1 Attachment]





   

  







 para master



 sy minta tulung dung, udah coba rumus buat gabungin data
 teks dgn tanggal tapi
 kok gagal terus ya?

 format cellnya selalu muncul angka padahal rumusnya udah sy
 cek dan sama sekali
 ga ada yg beda dgn contoh rumusnya (di sheet 2)

 (file terlampir)



 mohon bantuannya master,

 tks bgt ya 


   
























 #yiv0678692567 #yiv0678692567 --
   #yiv0678692567ygrp-mkp {
 border:1px solid #d8d8d8;font-family:Arial;margin:10px
 0;padding:0 10px;}

 #yiv0678692567 #yiv0678692567ygrp-mkp hr {
 border:1px solid #d8d8d8;}

 #yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567hd {
 color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
 0;}

 #yiv0678692567 #yiv0678692567ygrp-mkp #yiv0678692567ads {
 margin-bottom:10px;}

 #yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad {
 padding:0 0;}

 #yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad p {
 margin:0;}

 #yiv0678692567 #yiv0678692567ygrp-mkp .yiv0678692567ad a {
 color:#0000ff;text-decoration:none;}
 #yiv0678692567 #yiv0678692567ygrp-sponsor
 #yiv0678692567ygrp-lc {
 font-family:Arial;}

 #yiv0678692567 #yiv0678692567ygrp-sponsor
 #yiv0678692567ygrp-lc #yiv0678692567hd {
 margin:10px
 0px;font-weight:700;font-size:78%;line-height:122%;}

 #yiv0678692567 #yiv0678692567ygrp-sponsor
 #yiv0678692567ygrp-lc .yiv0678692567ad {
 margin-bottom:10px;padding:0 0;}


 #yiv0678692567 #yiv0678692567actions {
 font-family:Verdana;font-size:11px;padding:10px 0;}

 #yiv0678692567 #yiv0678692567activity {
 
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}


 #yiv0678692567 #yiv0678692567activity span {
 font-weight:700;}

 #yiv0678692567 #yiv0678692567activity span:first-child {
 text-transform:uppercase;}

 #yiv0678692567 #yiv0678692567activity span a {
 color:#5085b6;text-decoration:none;}

 #yiv0678692567 #yiv0678692567activity span span {
 color:#ff7900;}

 #yiv0678692567 #yiv0678692567activity span
 .yiv0678692567underline {
 text-decoration:underline;}

 #yiv0678692567 .yiv0678692567attach {
 clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
 0;width:400px;}

 #yiv0678692567 .yiv0678692567attach div a {
 text-decoration:none;}

 #yiv0678692567 .yiv0678692567attach img {
 border:none;padding-right:5px;}

 #yiv0678692567 .yiv0678692567attach label {
 display:block;margin-bottom:5px;}

 #yiv0678692567 .yiv0678692567attach label a {

 text-decoration:none;}

 #yiv0678692567 blockquote {
 margin:0 0 0 4px;}


 #yiv0678692567 .yiv0678692567bold {
 font-family:Arial;font-size:13px;font-weight:700;}

 #yiv0678692567 .yiv0678692567bold a {
 text-decoration:none;}

 #yiv0678692567 dd.yiv0678692567last p a {
 font-family:Verdana;font-weight:700;}

 #yiv0678692567 dd.yiv0678692567last p span {
 margin-right:10px;font-family:Verdana;font-weight:700;}

 #yiv0678692567 dd.yiv0678692567last p
 span.yiv0678692567yshortcuts {
 margin-right:0;}

 #yiv0678692567 div.yiv0678692567attach-table div div a {
 text-decoration:none;}

 #yiv0678692567 div.yiv0678692567attach-table {
 width:400px;}

 #yiv0678692567 div.yiv0678692567file-title a, #yiv0678692567
 div.yiv0678692567file-title a:active, #yiv0678692567
 div.yiv0678692567file-title a:hover, #yiv0678692567
 div.yiv0678692567file-title a:visited {
 text-decoration:none;}

 #yiv0678692567 div.yiv0678692567photo-title a,
 #yiv0678692567 div.yiv0678692567photo-title a:active,
 #yiv0678692567 div.yiv0678692567photo-title a:hover,
 #yiv0678692567 div.yiv0678692567photo-title a:visited {
 text-decoration:none;}

 #yiv0678692567 div#yiv0678692567ygrp-mlmsg
 #yiv0678692567ygrp-msg p a span.yiv0678692567yshortcuts {
 font-family:Verdana;font-size:10px;font-weight:normal;}

 #yiv0678692567 .yiv0678692567green {
 color:#628c2a;}

 #yiv0678692567 .yiv0678692567MsoNormal {
 margin:0 0 0 0;}

 #yiv0678692567 o {
 font-size:0;}

 #yiv0678692567 #yiv0678692567photos div {
 float:left;width:72px;}

 #yiv0678692567 #yiv0678692567photos div div {
 border:1px solid
 #666666;height:62px;overflow:hidden;width:62px;}

 #yiv0678692567 #yiv0678692567photos div label {
 
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

 #yiv0678692567 #yiv0678692567reco-category {
 font-size:77%;}

 #yiv0678692567 #yiv0678692567reco-desc {
 font-size:77%;}

 #yiv0678692567 .yiv0678692567replbq {
 margin:4px;}

 #yiv0678692567 #yiv0678692567ygrp-actbar div a:first-child {
 margin-right:2px;padding-right:5px;}

 #yiv0678692567 #yiv0678692567ygrp-mlmsg {
 font-size:13px;font-family:Arial, helvetica, clean,
 sans-serif;}

 #yiv0678692567 #yiv0678692567ygrp-mlmsg table {
 font-size:inherit;font:100%;}

 #yiv0678692567 #yiv0678692567ygrp-mlmsg select,
 #yiv0678692567 input, #yiv0678692567 textarea {
 font:99% Arial, Helvetica, clean, sans-serif;}

 #yiv0678692567 #yiv0678692567ygrp-mlmsg pre, #yiv0678692567
 code {
 font:115% monospace;}

 #yiv0678692567 #yiv0678692567ygrp-mlmsg * {
 line-height:1.22em;}

 #yiv0678692567 #yiv0678692567ygrp-mlmsg #yiv0678692567logo {
 padding-bottom:10px;}


 #yiv0678692567 #yiv0678692567ygrp-msg p a {
 font-family:Verdana;}

 #yiv0678692567 #yiv0678692567ygrp-msg
 p#yiv0678692567attach-count span {
 color:#1E66AE;font-weight:700;}

 #yiv0678692567 #yiv0678692567ygrp-reco
 #yiv0678692567reco-head {
 color:#ff7900;font-weight:700;}

 #yiv0678692567 #yiv0678692567ygrp-reco {
 margin-bottom:20px;padding:0px;}

 #yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
 li a {
 font-size:130%;text-decoration:none;}

 #yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
 li {
 font-size:77%;list-style-type:square;padding:6px 0;}

 #yiv0678692567 #yiv0678692567ygrp-sponsor #yiv0678692567ov
 ul {
 margin:0;padding:0 0 0 8px;}

 #yiv0678692567 #yiv0678692567ygrp-text {
 font-family:Georgia;}

 #yiv0678692567 #yiv0678692567ygrp-text p {
 margin:0 0 1em 0;}

 #yiv0678692567 #yiv0678692567ygrp-text tt {
 font-size:120%;}

 #yiv0678692567 #yiv0678692567ygrp-vital ul li:last-child {
 border-right:none !important;
 }
 #yiv0678692567

Attachment: latihan euy.xlsx
Description: MS-Excel 2007 spreadsheet

Kirim email ke