3 Messages
Digest #3400
Messages
Fri Apr 24, 2015 2:33 am (PDT) . Posted by:
"Dede"
Dear BeExceler,
Apa rumus yg tepat untuk kolom warna kuning yah?
Salam
DD
________________________________
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
Apa rumus yg tepat untuk kolom warna kuning yah?
Salam
DD
____________
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
Fri Apr 24, 2015 12:03 pm (PDT) . Posted by:
"Andrie -" sioean2
Dear DD,
Dicoba rumus berikut :Kepuluhan : =ROUNDUP(B3,-1)Keratusan : =ROUNDUP(B3,-2)
Regards,Andrie
From: "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, April 24, 2015 4:33 PM
Subject: [belajar-excel] Rubah Angka [1 Attachment]
Dear BeExceler, Apa rumus yg tepat untuk kolom warna kuning yah? Salam DD
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
#yiv3903567296 #yiv3903567296 -- #yiv3903567296ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3903567296 #yiv3903567296ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3903567296 #yiv3903567296ygrp-mkp #yiv3903567296hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3903567296 #yiv3903567296ygrp-mkp #yiv3903567296ads {margin-bottom:10px;}#yiv3903567296 #yiv3903567296ygrp-mkp .yiv3903567296ad {padding:0 0;}#yiv3903567296 #yiv3903567296ygrp-mkp .yiv3903567296ad p {margin:0;}#yiv3903567296 #yiv3903567296ygrp-mkp .yiv3903567296ad a {color:#0000ff;text-decoration:none;}#yiv3903567296 #yiv3903567296ygrp-sponsor #yiv3903567296ygrp-lc {font-family:Arial;}#yiv3903567296 #yiv3903567296ygrp-sponsor #yiv3903567296ygrp-lc #yiv3903567296hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3903567296 #yiv3903567296ygrp-sponsor #yiv3903567296ygrp-lc .yiv3903567296ad {margin-bottom:10px;padding:0 0;}#yiv3903567296 #yiv3903567296actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3903567296 #yiv3903567296activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3903567296 #yiv3903567296activity span {font-weight:700;}#yiv3903567296 #yiv3903567296activity span:first-child {text-transform:uppercase;}#yiv3903567296 #yiv3903567296activity span a {color:#5085b6;text-decoration:none;}#yiv3903567296 #yiv3903567296activity span span {color:#ff7900;}#yiv3903567296 #yiv3903567296activity span .yiv3903567296underline {text-decoration:underline;}#yiv3903567296 .yiv3903567296attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3903567296 .yiv3903567296attach div a {text-decoration:none;}#yiv3903567296 .yiv3903567296attach img {border:none;padding-right:5px;}#yiv3903567296 .yiv3903567296attach label {display:block;margin-bottom:5px;}#yiv3903567296 .yiv3903567296attach label a {text-decoration:none;}#yiv3903567296 blockquote {margin:0 0 0 4px;}#yiv3903567296 .yiv3903567296bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3903567296 .yiv3903567296bold a {text-decoration:none;}#yiv3903567296 dd.yiv3903567296last p a {font-family:Verdana;font-weight:700;}#yiv3903567296 dd.yiv3903567296last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3903567296 dd.yiv3903567296last p span.yiv3903567296yshortcuts {margin-right:0;}#yiv3903567296 div.yiv3903567296attach-table div div a {text-decoration:none;}#yiv3903567296 div.yiv3903567296attach-table {width:400px;}#yiv3903567296 div.yiv3903567296file-title a, #yiv3903567296 div.yiv3903567296file-title a:active, #yiv3903567296 div.yiv3903567296file-title a:hover, #yiv3903567296 div.yiv3903567296file-title a:visited {text-decoration:none;}#yiv3903567296 div.yiv3903567296photo-title a, #yiv3903567296 div.yiv3903567296photo-title a:active, #yiv3903567296 div.yiv3903567296photo-title a:hover, #yiv3903567296 div.yiv3903567296photo-title a:visited {text-decoration:none;}#yiv3903567296 div#yiv3903567296ygrp-mlmsg #yiv3903567296ygrp-msg p a span.yiv3903567296yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3903567296 .yiv3903567296green {color:#628c2a;}#yiv3903567296 .yiv3903567296MsoNormal {margin:0 0 0 0;}#yiv3903567296 o {font-size:0;}#yiv3903567296 #yiv3903567296photos div {float:left;width:72px;}#yiv3903567296 #yiv3903567296photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3903567296 #yiv3903567296photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3903567296 #yiv3903567296reco-category {font-size:77%;}#yiv3903567296 #yiv3903567296reco-desc {font-size:77%;}#yiv3903567296 .yiv3903567296replbq {margin:4px;}#yiv3903567296 #yiv3903567296ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3903567296 #yiv3903567296ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3903567296 #yiv3903567296ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3903567296 #yiv3903567296ygrp-mlmsg select, #yiv3903567296 input, #yiv3903567296 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3903567296 #yiv3903567296ygrp-mlmsg pre, #yiv3903567296 code {font:115% monospace;}#yiv3903567296 #yiv3903567296ygrp-mlmsg * {line-height:1.22em;}#yiv3903567296 #yiv3903567296ygrp-mlmsg #yiv3903567296logo {padding-bottom:10px;}#yiv3903567296 #yiv3903567296ygrp-msg p a {font-family:Verdana;}#yiv3903567296 #yiv3903567296ygrp-msg p#yiv3903567296attach-count span {color:#1E66AE;font-weight:700;}#yiv3903567296 #yiv3903567296ygrp-reco #yiv3903567296reco-head {color:#ff7900;font-weight:700;}#yiv3903567296 #yiv3903567296ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3903567296 #yiv3903567296ygrp-sponsor #yiv3903567296ov li a {font-size:130%;text-decoration:none;}#yiv3903567296 #yiv3903567296ygrp-sponsor #yiv3903567296ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3903567296 #yiv3903567296ygrp-sponsor #yiv3903567296ov ul {margin:0;padding:0 0 0 8px;}#yiv3903567296 #yiv3903567296ygrp-text {font-family:Georgia;}#yiv3903567296 #yiv3903567296ygrp-text p {margin:0 0 1em 0;}#yiv3903567296 #yiv3903567296ygrp-text tt {font-size:120%;}#yiv3903567296 #yiv3903567296ygrp-vital ul li:last-child {border-right:none !important;}#yiv3903567296
Dicoba rumus berikut :Kepuluhan : =ROUNDUP(B3,-1)Keratusan : =ROUNDUP(B3,-2)
Regards,Andrie
From: "Dede pmaho_log4@nabatisnack.co.id [belajar-excel]" <belajar-excel@yahoogroups.com>
To: belajar-excel@yahoogroups.com
Sent: Friday, April 24, 2015 4:33 PM
Subject: [belajar-excel] Rubah Angka [1 Attachment]
Dear BeExceler, Apa rumus yg tepat untuk kolom warna kuning yah? Salam DD
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
#yiv3903567296 #yiv3903567296 -- #yiv3903567296ygrp-
Fri Apr 24, 2015 12:40 pm (PDT) . Posted by:
"Mr. Kid" nmkid.family@ymail.com
Kalau mau pakai yang MS Calendar 12, maka install ms access 2007
> jika akan diletakkan dalam worksheet,
|| ribbon Developer -> group Controls -> Insert -> bagian ActiveX Control
-> klik Additional Control -> pilih MS Calendar 12 -> gambar kotak object
calendar dalam worksheet
> jika akan digunakan dalam sebuah userform
|| buat userform -> klik kanan toolbox yang ada -> additional control ->
pilih MS Calendar 12
atau
|| buat userform -> menu Tools -> additional control -> pilih MS Calnedar 12
> jika akan dirujuk saja dalam VBE
|| di VBE -> menu Tools -> References -> klik Browse -> cari file mscal.ocx
-> OK sampai kembali ke VBE
Wassalam,
Kid
2015-04-24 11:10 GMT+10:00 'prazt' praztmath@gmail.com [belajar-excel] <
belajar-excel@yahoogroups.com>:
>
>
> Suwun atas sarannya Mr.Kid, ane pake excel 2007, knnapa kl pake ms
> Calendaer 12 ga bisa ya, bisanya pakai yg 11..sekali lagi makasih.
>
>
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com]
> *Sent:* 22 April 2015 7:35
> *To:* BeExcel
> *Subject:* Re: [belajar-excel] menampilkan list tanggal pada cell excel
> 2007
>
>
>
>
>
> Wa'alaikumussalam wr wb
>
> Tambahkan referensi library ke MSCAL.ocx di VBE dengan menu Tools ->
> references -> cari MS Calendar blabla -> centang OK
>
> Wassalamu'alaikum wr wb
>
> Kid
>
>
>
>
>
>
>
> 2015-04-18 12:48 GMT+10:00 'prazt' praztmath@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>
>
> Assalamu'alikum..
>
> Dear rekan semua..mohon bantuannya gimana script yang benar untuk
> menampilkan list tanggal (kalender) pada cell excel 2007 seperti yang sudah
> dibahas oleh mr.HK pada [image:
> http://milis-belajar-excel.1048464.n5.nabble.com/images/icon_attachment.gif]*Calendar
> Control 2010.xlsm* (33K) Download Attachment
> <http://milis-belajar-excel.1048464.n5.nabble.com/attachment/5719946/0/Calendar%20Control%202010.xlsm>
> ,saya coba copy paste script tersebut di excel 2007 kok error alias debug
> ya padahal kalau saya buka langsung hasil downlodnya bisa jalan. Mohon
> pencerahannya para suhu. Terimakasih sebelumnya..
>
> Wassalamu'alaikum..
>
>
>
>
>
> jika akan diletakkan dalam worksheet,
|| ribbon Developer -> group Controls -> Insert -> bagian ActiveX Control
-> klik Additional Control -> pilih MS Calendar 12 -> gambar kotak object
calendar dalam worksheet
> jika akan digunakan dalam sebuah userform
|| buat userform -> klik kanan toolbox yang ada -> additional control ->
pilih MS Calendar 12
atau
|| buat userform -> menu Tools -> additional control -> pilih MS Calnedar 12
> jika akan dirujuk saja dalam VBE
|| di VBE -> menu Tools -> References -> klik Browse -> cari file mscal.ocx
-> OK sampai kembali ke VBE
Wassalam,
Kid
2015-04-24 11:10 GMT+10:00 'prazt' praztmath@gmail.com [belajar-excel] <
belajar-excel@yahoogroups.com>:
>
>
> Suwun atas sarannya Mr.Kid, ane pake excel 2007, knnapa kl pake ms
> Calendaer 12 ga bisa ya, bisanya pakai yg 11..sekali lagi makasih.
>
>
>
> *From:* belajar-excel@yahoogroups.com [mailto:
> belajar-excel@yahoogroups.com]
> *Sent:* 22 April 2015 7:35
> *To:* BeExcel
> *Subject:* Re: [belajar-excel] menampilkan list tanggal pada cell excel
> 2007
>
>
>
>
>
> Wa'alaikumussalam wr wb
>
> Tambahkan referensi library ke MSCAL.ocx di VBE dengan menu Tools ->
> references -> cari MS Calendar blabla -> centang OK
>
> Wassalamu'alaikum wr wb
>
> Kid
>
>
>
>
>
>
>
> 2015-04-18 12:48 GMT+10:00 'prazt' praztmath@gmail.com [belajar-excel] <
> belajar-excel@yahoogroups.com>:
>
>
>
> Assalamu'alikum..
>
> Dear rekan semua..mohon bantuannya gimana script yang benar untuk
> menampilkan list tanggal (kalender) pada cell excel 2007 seperti yang sudah
> dibahas oleh mr.HK pada [image:
> http://milis-belajar-excel.1048464.n5.nabble.com/images/icon_attachment.gif]*Calendar
> Control 2010.xlsm* (33K) Download Attachment
> <http://milis-belajar-excel.1048464.n5.nabble.com/attachment/5719946/0/Calendar%20Control%202010.xlsm>
> ,saya coba copy paste script tersebut di excel 2007 kok error alias debug
> ya padahal kalau saya buka langsung hasil downlodnya bisa jalan. Mohon
> pencerahannya para suhu. Terimakasih sebelumnya..
>
> Wassalamu'alaikum..
>
>
>
>
>
============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
Tidak ada komentar:
Posting Komentar