bias di share contohnya...
Pada Selasa, 8 Desember 2015 11:09, "imam cahyo yuwono [email protected]
[belajar-excel]" <[email protected]> menulis:
Assalamualaikum Wr. Wb.dear para expertsaya membuat form entry dengan data
base di worksheet namun antara format di form dan di worsheet berbeda di form
formatnya DD-MM-YYYY sedang di wrksheet MM-DD-YYYY, sudah saya rubah settingan
mulai dari komputer sampai di excel nya, apakah harus ditambah scriptnya dan
bagaimana scripnya agar dari cel b3 sampai kebawah tidak berubah
terima kasih
Wassalamualaikum Wr. Wb
#yiv0500273813 #yiv0500273813 -- #yiv0500273813ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0500273813
#yiv0500273813ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0500273813
#yiv0500273813ygrp-mkp #yiv0500273813hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv0500273813 #yiv0500273813ygrp-mkp #yiv0500273813ads
{margin-bottom:10px;}#yiv0500273813 #yiv0500273813ygrp-mkp .yiv0500273813ad
{padding:0 0;}#yiv0500273813 #yiv0500273813ygrp-mkp .yiv0500273813ad p
{margin:0;}#yiv0500273813 #yiv0500273813ygrp-mkp .yiv0500273813ad a
{color:#0000ff;text-decoration:none;}#yiv0500273813 #yiv0500273813ygrp-sponsor
#yiv0500273813ygrp-lc {font-family:Arial;}#yiv0500273813
#yiv0500273813ygrp-sponsor #yiv0500273813ygrp-lc #yiv0500273813hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0500273813
#yiv0500273813ygrp-sponsor #yiv0500273813ygrp-lc .yiv0500273813ad
{margin-bottom:10px;padding:0 0;}#yiv0500273813 #yiv0500273813actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0500273813
#yiv0500273813activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0500273813
#yiv0500273813activity span {font-weight:700;}#yiv0500273813
#yiv0500273813activity span:first-child
{text-transform:uppercase;}#yiv0500273813 #yiv0500273813activity span a
{color:#5085b6;text-decoration:none;}#yiv0500273813 #yiv0500273813activity span
span {color:#ff7900;}#yiv0500273813 #yiv0500273813activity span
.yiv0500273813underline {text-decoration:underline;}#yiv0500273813
.yiv0500273813attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv0500273813 .yiv0500273813attach div a
{text-decoration:none;}#yiv0500273813 .yiv0500273813attach img
{border:none;padding-right:5px;}#yiv0500273813 .yiv0500273813attach label
{display:block;margin-bottom:5px;}#yiv0500273813 .yiv0500273813attach label a
{text-decoration:none;}#yiv0500273813 blockquote {margin:0 0 0
4px;}#yiv0500273813 .yiv0500273813bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0500273813
.yiv0500273813bold a {text-decoration:none;}#yiv0500273813 dd.yiv0500273813last
p a {font-family:Verdana;font-weight:700;}#yiv0500273813 dd.yiv0500273813last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0500273813
dd.yiv0500273813last p span.yiv0500273813yshortcuts
{margin-right:0;}#yiv0500273813 div.yiv0500273813attach-table div div a
{text-decoration:none;}#yiv0500273813 div.yiv0500273813attach-table
{width:400px;}#yiv0500273813 div.yiv0500273813file-title a, #yiv0500273813
div.yiv0500273813file-title a:active, #yiv0500273813
div.yiv0500273813file-title a:hover, #yiv0500273813 div.yiv0500273813file-title
a:visited {text-decoration:none;}#yiv0500273813 div.yiv0500273813photo-title a,
#yiv0500273813 div.yiv0500273813photo-title a:active, #yiv0500273813
div.yiv0500273813photo-title a:hover, #yiv0500273813
div.yiv0500273813photo-title a:visited {text-decoration:none;}#yiv0500273813
div#yiv0500273813ygrp-mlmsg #yiv0500273813ygrp-msg p a
span.yiv0500273813yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0500273813
.yiv0500273813green {color:#628c2a;}#yiv0500273813 .yiv0500273813MsoNormal
{margin:0 0 0 0;}#yiv0500273813 o {font-size:0;}#yiv0500273813
#yiv0500273813photos div {float:left;width:72px;}#yiv0500273813
#yiv0500273813photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv0500273813
#yiv0500273813photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0500273813
#yiv0500273813reco-category {font-size:77%;}#yiv0500273813
#yiv0500273813reco-desc {font-size:77%;}#yiv0500273813 .yiv0500273813replbq
{margin:4px;}#yiv0500273813 #yiv0500273813ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv0500273813 #yiv0500273813ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0500273813
#yiv0500273813ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0500273813
#yiv0500273813ygrp-mlmsg select, #yiv0500273813 input, #yiv0500273813 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0500273813
#yiv0500273813ygrp-mlmsg pre, #yiv0500273813 code {font:115%
monospace;}#yiv0500273813 #yiv0500273813ygrp-mlmsg *
{line-height:1.22em;}#yiv0500273813 #yiv0500273813ygrp-mlmsg #yiv0500273813logo
{padding-bottom:10px;}#yiv0500273813 #yiv0500273813ygrp-msg p a
{font-family:Verdana;}#yiv0500273813 #yiv0500273813ygrp-msg
p#yiv0500273813attach-count span {color:#1E66AE;font-weight:700;}#yiv0500273813
#yiv0500273813ygrp-reco #yiv0500273813reco-head
{color:#ff7900;font-weight:700;}#yiv0500273813 #yiv0500273813ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv0500273813 #yiv0500273813ygrp-sponsor
#yiv0500273813ov li a {font-size:130%;text-decoration:none;}#yiv0500273813
#yiv0500273813ygrp-sponsor #yiv0500273813ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0500273813
#yiv0500273813ygrp-sponsor #yiv0500273813ov ul {margin:0;padding:0 0 0
8px;}#yiv0500273813 #yiv0500273813ygrp-text
{font-family:Georgia;}#yiv0500273813 #yiv0500273813ygrp-text p {margin:0 0 1em
0;}#yiv0500273813 #yiv0500273813ygrp-text tt {font-size:120%;}#yiv0500273813
#yiv0500273813ygrp-vital ul li:last-child {border-right:none
!important;}#yiv0500273813
