Dear Heri,
Biasanya tergantung dari Database yang kita tarik (biasanya memang dalam bentuk
text), apakan pada saat pembuatannya sudah sesuai dengan data yang ada, artinya
setiap field2 yang di buatnya sudah sesuai dengan mandatorynya,apakah bentuk
text atau number..Untuk mengatasinya, kita harus merubah datanya menjadi apa
yang kita inginginkan, apakah number atau text.
TerimaKasih.
Pada Kamis, 16 Juni 2016 13:26, "'Heri Pamungkas ( Gmail )'
[email protected] [belajar-excel]" <[email protected]> menulis:
--
السَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Semangat pagi,.
Dear Rekan-Rekan,
Saya mencoba fitur Get Eksternal data Connect ke Dirinya.
Alhamdulillah berhasil, tapi muncul problem.
Kenapa ya Datanya tidak bisa di komputasi (Angka berupa Teks).
Adakah Rekan-rekan yang pernah seperti ini ?! Bagaimana ya solusinya ?!
وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ
Warm Regards,
#yiv4589051120 #yiv4589051120 -- #yiv4589051120ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4589051120
#yiv4589051120ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4589051120
#yiv4589051120ygrp-mkp #yiv4589051120hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv4589051120 #yiv4589051120ygrp-mkp #yiv4589051120ads
{margin-bottom:10px;}#yiv4589051120 #yiv4589051120ygrp-mkp .yiv4589051120ad
{padding:0 0;}#yiv4589051120 #yiv4589051120ygrp-mkp .yiv4589051120ad p
{margin:0;}#yiv4589051120 #yiv4589051120ygrp-mkp .yiv4589051120ad a
{color:#0000ff;text-decoration:none;}#yiv4589051120 #yiv4589051120ygrp-sponsor
#yiv4589051120ygrp-lc {font-family:Arial;}#yiv4589051120
#yiv4589051120ygrp-sponsor #yiv4589051120ygrp-lc #yiv4589051120hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4589051120
#yiv4589051120ygrp-sponsor #yiv4589051120ygrp-lc .yiv4589051120ad
{margin-bottom:10px;padding:0 0;}#yiv4589051120 #yiv4589051120actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4589051120
#yiv4589051120activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4589051120
#yiv4589051120activity span {font-weight:700;}#yiv4589051120
#yiv4589051120activity span:first-child
{text-transform:uppercase;}#yiv4589051120 #yiv4589051120activity span a
{color:#5085b6;text-decoration:none;}#yiv4589051120 #yiv4589051120activity span
span {color:#ff7900;}#yiv4589051120 #yiv4589051120activity span
.yiv4589051120underline {text-decoration:underline;}#yiv4589051120
.yiv4589051120attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv4589051120 .yiv4589051120attach div a
{text-decoration:none;}#yiv4589051120 .yiv4589051120attach img
{border:none;padding-right:5px;}#yiv4589051120 .yiv4589051120attach label
{display:block;margin-bottom:5px;}#yiv4589051120 .yiv4589051120attach label a
{text-decoration:none;}#yiv4589051120 blockquote {margin:0 0 0
4px;}#yiv4589051120 .yiv4589051120bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv4589051120
.yiv4589051120bold a {text-decoration:none;}#yiv4589051120 dd.yiv4589051120last
p a {font-family:Verdana;font-weight:700;}#yiv4589051120 dd.yiv4589051120last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4589051120
dd.yiv4589051120last p span.yiv4589051120yshortcuts
{margin-right:0;}#yiv4589051120 div.yiv4589051120attach-table div div a
{text-decoration:none;}#yiv4589051120 div.yiv4589051120attach-table
{width:400px;}#yiv4589051120 div.yiv4589051120file-title a, #yiv4589051120
div.yiv4589051120file-title a:active, #yiv4589051120
div.yiv4589051120file-title a:hover, #yiv4589051120 div.yiv4589051120file-title
a:visited {text-decoration:none;}#yiv4589051120 div.yiv4589051120photo-title a,
#yiv4589051120 div.yiv4589051120photo-title a:active, #yiv4589051120
div.yiv4589051120photo-title a:hover, #yiv4589051120
div.yiv4589051120photo-title a:visited {text-decoration:none;}#yiv4589051120
div#yiv4589051120ygrp-mlmsg #yiv4589051120ygrp-msg p a
span.yiv4589051120yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4589051120
.yiv4589051120green {color:#628c2a;}#yiv4589051120 .yiv4589051120MsoNormal
{margin:0 0 0 0;}#yiv4589051120 o {font-size:0;}#yiv4589051120
#yiv4589051120photos div {float:left;width:72px;}#yiv4589051120
#yiv4589051120photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv4589051120
#yiv4589051120photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4589051120
#yiv4589051120reco-category {font-size:77%;}#yiv4589051120
#yiv4589051120reco-desc {font-size:77%;}#yiv4589051120 .yiv4589051120replbq
{margin:4px;}#yiv4589051120 #yiv4589051120ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv4589051120 #yiv4589051120ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4589051120
#yiv4589051120ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4589051120
#yiv4589051120ygrp-mlmsg select, #yiv4589051120 input, #yiv4589051120 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv4589051120
#yiv4589051120ygrp-mlmsg pre, #yiv4589051120 code {font:115%
monospace;}#yiv4589051120 #yiv4589051120ygrp-mlmsg *
{line-height:1.22em;}#yiv4589051120 #yiv4589051120ygrp-mlmsg #yiv4589051120logo
{padding-bottom:10px;}#yiv4589051120 #yiv4589051120ygrp-msg p a
{font-family:Verdana;}#yiv4589051120 #yiv4589051120ygrp-msg
p#yiv4589051120attach-count span {color:#1E66AE;font-weight:700;}#yiv4589051120
#yiv4589051120ygrp-reco #yiv4589051120reco-head
{color:#ff7900;font-weight:700;}#yiv4589051120 #yiv4589051120ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv4589051120 #yiv4589051120ygrp-sponsor
#yiv4589051120ov li a {font-size:130%;text-decoration:none;}#yiv4589051120
#yiv4589051120ygrp-sponsor #yiv4589051120ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv4589051120
#yiv4589051120ygrp-sponsor #yiv4589051120ov ul {margin:0;padding:0 0 0
8px;}#yiv4589051120 #yiv4589051120ygrp-text
{font-family:Georgia;}#yiv4589051120 #yiv4589051120ygrp-text p {margin:0 0 1em
0;}#yiv4589051120 #yiv4589051120ygrp-text tt {font-size:120%;}#yiv4589051120
#yiv4589051120ygrp-vital ul li:last-child {border-right:none
!important;}#yiv4589051120
