Re: [belajar-excel] Menarik otomatis Master Data Sesuai Data Validation

[teguh indrawanto teguh.indrawa...@yahoo.com [belajar-excel]]

Dear Mr. Kid,
Terima kasih banyak atas solusi serta pencerahannya. Saya akan coba 
implementasikan.dan terima kasih juga atas share blognya..
Regards,
Teguh




 On Tuesday, April 21, 2015 11:10 AM, "'Mr. Kid' mr.nm...@gmail.com 
[belajar-excel]"  wrote:



     Hai Teguh,


Filtering bisa dilakukan dengan array formula filtering seperti coretan yang 
ada disini.
File terlampir dengan cara lainnya, termasuk kemungkinan untuk menghilangkan 
kolom Total Price dari master data.


Wassalam,
Kid








2015-04-20 14:46 GMT+10:00 teguh indrawanto teguh.indrawa...@yahoo.com 
[belajar-excel] :


     Dear Master Excel,
Bagaimana caranya untuk menarik semua data secara otomatis sesuai data 
validation yang kita pilih ?
berikut terlampir penjelasan soalnya.
Mohon bantuannya !
Atas perhatian serta bantuannya diucapkan banyak terima kasih.
Regards,
Teguh







  #yiv8994902585 #yiv8994902585 -- #yiv8994902585ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8994902585 
#yiv8994902585ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8994902585 
#yiv8994902585ygrp-mkp #yiv8994902585hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8994902585 #yiv8994902585ygrp-mkp #yiv8994902585ads 
{margin-bottom:10px;}#yiv8994902585 #yiv8994902585ygrp-mkp .yiv8994902585ad 
{padding:0 0;}#yiv8994902585 #yiv8994902585ygrp-mkp .yiv8994902585ad p 
{margin:0;}#yiv8994902585 #yiv8994902585ygrp-mkp .yiv8994902585ad a 
{color:#ff;text-decoration:none;}#yiv8994902585 #yiv8994902585ygrp-sponsor 
#yiv8994902585ygrp-lc {font-family:Arial;}#yiv8994902585 
#yiv8994902585ygrp-sponsor #yiv8994902585ygrp-lc #yiv8994902585hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8994902585 
#yiv8994902585ygrp-sponsor #yiv8994902585ygrp-lc .yiv8994902585ad 
{margin-bottom:10px;padding:0 0;}#yiv8994902585 #yiv8994902585actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8994902585 
#yiv8994902585activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8994902585
 #yiv8994902585activity span {font-weight:700;}#yiv8994902585 
#yiv8994902585activity span:first-child 
{text-transform:uppercase;}#yiv8994902585 #yiv8994902585activity span a 
{color:#5085b6;text-decoration:none;}#yiv8994902585 #yiv8994902585activity span 
span {color:#ff7900;}#yiv8994902585 #yiv8994902585activity span 
.yiv8994902585underline {text-decoration:underline;}#yiv8994902585 
.yiv8994902585attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8994902585 .yiv8994902585attach div a 
{text-decoration:none;}#yiv8994902585 .yiv8994902585attach img 
{border:none;padding-right:5px;}#yiv8994902585 .yiv8994902585attach label 
{display:block;margin-bottom:5px;}#yiv8994902585 .yiv8994902585attach label a 
{text-decoration:none;}#yiv8994902585 blockquote {margin:0 0 0 
4px;}#yiv8994902585 .yiv8994902585bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8994902585 
.yiv8994902585bold a {text-decoration:none;}#yiv8994902585 dd.yiv8994902585last 
p a {font-family:Verdana;font-weight:700;}#yiv8994902585 dd.yiv8994902585last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8994902585 
dd.yiv8994902585last p span.yiv8994902585yshortcuts 
{margin-right:0;}#yiv8994902585 div.yiv8994902585attach-table div div a 
{text-decoration:none;}#yiv8994902585 div.yiv8994902585attach-table 
{width:400px;}#yiv8994902585 div.yiv8994902585file-title a, #yiv8994902585 
div.yiv8994902585file-title a:active, #yiv8994902585 
div.yiv8994902585file-title a:hover, #yiv8994902585 div.yiv8994902585file-title 
a:visited {text-decoration:none;}#yiv8994902585 div.yiv8994902585photo-title a, 
#yiv8994902585 div.yiv8994902585photo-title a:active, #yiv8994902585 
div.yiv8994902585photo-title a:hover, #yiv8994902585 
div.yiv8994902585photo-title a:visited {text-decoration:none;}#yiv8994902585 
div#yiv8994902585ygrp-mlmsg #yiv8994902585ygrp-msg p a 
span.yiv8994902585yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8994902585 
.yiv8994902585green {color:#628c2a;}#yiv8994902585 .yiv8994902585MsoNormal 
{margin:0 0 0 0;}#yiv8994902585 o {font-size:0;}#yiv8994902585 
#yiv8994902585photos div {float:left;width:72px;}#yiv8994902585 
#yiv8994902585photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv8994902585 
#yiv8994902585photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8994902585
 #yiv8994902585reco-category {font-size:77%;}#yiv8994902585 
#yiv8994902585reco-desc {font-size:77%;}#yiv8994902585 .yiv8994902585replbq 
{margin:4px;}#yiv8994902585 #yiv8994902585ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv8994902585 #yiv8994902585ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8994902585 
#yiv8994902585ygrp-mlmsg table {font-size:inherit;font:

[belajar-excel] Memunculkan nama sheet

[Danny Prasetyo danny_06...@yahoo.com [belajar-excel]]

Re: [belajar-excel] Cara Membuat Data dengan Baris Berurut [1 Attachment]

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Hai Seismica,Coba pakai kolom bantu disamping Inputnya dan gunakan fungsi 
Vlookup untuk Hasilnya, dengan memakai kolom bantu tersebut sebagai Lookup 
Value.File jawaban terlampir.
Salam,HK
  From: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" 

 To: belajar-excel@yahoogroups.com 
 Sent: Tuesday, 21 April 2015, 8:17
 Subject: [belajar-excel] Cara Membuat Data dengan Baris Berurut [1 Attachment]
   
    Assalamu'alaikum wrwbMohon bantuan lagi para master...Cara Membuat Data 
dengan Baris Berurut seperti contoh terlampir..:)WassalamSeismica
   #yiv0439491327 -- #yiv0439491327ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0439491327 
#yiv0439491327ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0439491327 
#yiv0439491327ygrp-mkp #yiv0439491327hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0439491327 #yiv0439491327ygrp-mkp #yiv0439491327ads 
{margin-bottom:10px;}#yiv0439491327 #yiv0439491327ygrp-mkp .yiv0439491327ad 
{padding:0 0;}#yiv0439491327 #yiv0439491327ygrp-mkp .yiv0439491327ad p 
{margin:0;}#yiv0439491327 #yiv0439491327ygrp-mkp .yiv0439491327ad a 
{color:#ff;text-decoration:none;}#yiv0439491327 #yiv0439491327ygrp-sponsor 
#yiv0439491327ygrp-lc {font-family:Arial;}#yiv0439491327 
#yiv0439491327ygrp-sponsor #yiv0439491327ygrp-lc #yiv0439491327hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0439491327 
#yiv0439491327ygrp-sponsor #yiv0439491327ygrp-lc .yiv0439491327ad 
{margin-bottom:10px;padding:0 0;}#yiv0439491327 #yiv0439491327actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0439491327 
#yiv0439491327activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0439491327
 #yiv0439491327activity span {font-weight:700;}#yiv0439491327 
#yiv0439491327activity span:first-child 
{text-transform:uppercase;}#yiv0439491327 #yiv0439491327activity span a 
{color:#5085b6;text-decoration:none;}#yiv0439491327 #yiv0439491327activity span 
span {color:#ff7900;}#yiv0439491327 #yiv0439491327activity span 
.yiv0439491327underline {text-decoration:underline;}#yiv0439491327 
.yiv0439491327attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0439491327 .yiv0439491327attach div a 
{text-decoration:none;}#yiv0439491327 .yiv0439491327attach img 
{border:none;padding-right:5px;}#yiv0439491327 .yiv0439491327attach label 
{display:block;margin-bottom:5px;}#yiv0439491327 .yiv0439491327attach label a 
{text-decoration:none;}#yiv0439491327 blockquote {margin:0 0 0 
4px;}#yiv0439491327 .yiv0439491327bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0439491327 
.yiv0439491327bold a {text-decoration:none;}#yiv0439491327 dd.yiv0439491327last 
p a {font-family:Verdana;font-weight:700;}#yiv0439491327 dd.yiv0439491327last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0439491327 
dd.yiv0439491327last p span.yiv0439491327yshortcuts 
{margin-right:0;}#yiv0439491327 div.yiv0439491327attach-table div div a 
{text-decoration:none;}#yiv0439491327 div.yiv0439491327attach-table 
{width:400px;}#yiv0439491327 div.yiv0439491327file-title a, #yiv0439491327 
div.yiv0439491327file-title a:active, #yiv0439491327 
div.yiv0439491327file-title a:hover, #yiv0439491327 div.yiv0439491327file-title 
a:visited {text-decoration:none;}#yiv0439491327 div.yiv0439491327photo-title a, 
#yiv0439491327 div.yiv0439491327photo-title a:active, #yiv0439491327 
div.yiv0439491327photo-title a:hover, #yiv0439491327 
div.yiv0439491327photo-title a:visited {text-decoration:none;}#yiv0439491327 
div#yiv0439491327ygrp-mlmsg #yiv0439491327ygrp-msg p a 
span.yiv0439491327yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0439491327 
.yiv0439491327green {color:#628c2a;}#yiv0439491327 .yiv0439491327MsoNormal 
{margin:0 0 0 0;}#yiv0439491327 o {font-size:0;}#yiv0439491327 
#yiv0439491327photos div {float:left;width:72px;}#yiv0439491327 
#yiv0439491327photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv0439491327 
#yiv0439491327photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0439491327
  #yiv0439491327reco-category {font-size:77%;}#yiv0439491327 
#yiv0439491327reco-desc {font-size:77%;}#yiv0439491327 .yiv0439491327replbq 
{margin:4px;}#yiv0439491327 #yiv0439491327ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0439491327 #yiv0439491327ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0439491327 
#yiv0439491327ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0439491327 
#yiv0439491327ygrp-mlmsg select, #yiv0439491327 input, #yiv0439491327 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0439491327 
#yiv0439491327ygrp-mlmsg pre, #yiv0439491327 code {font:115% 
monospace;}#yiv0439491327 #yiv0439491327ygrp-mlmsg * 
{line-height:1.22em;}#yiv0439491327 #yiv0

Re: [belajar-excel] Memunculkan nama sheet

[Hendrik Karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Hai Danny,
Coba ganti ActiveSheet dengan Sheets(Sheets.Count).

Salam,
HK


Sent from Samsung Mobile

 Original message From: "Danny Prasetyo 
danny_06...@yahoo.com [belajar-excel]"  
Date:21/04/2015  14:04  (GMT+07:00) To: 
belajar-excel@yahoogroups.com Subject: [belajar-excel] Memunculkan 
nama sheet 
Bagaimana caranya memunculkan nama sheet yang berada paling terakhir ke 
dalam combobox? 

Saya cuma tau caranya memunculkan nama sheet yang aktif, contohnya seperti ini

Private Sub userform_initialize ()
Combobox1.value = ActiveSheet.Name
End sub

Re: [belajar-excel] Memunculkan nama sheet

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

coba diganti:

untuk last sheet:
Set ws = Sheets(Sheets.Count)
Combobox1.Value = ws.CodeName

untuk last name sheet:

Set ws = Sheet(Sheets.Count)
Combobox1.Value = ws.Name

it's work in Office 2013 SP1.

Sent from Yahoo Mail on Android

Re: [belajar-excel] Memunculkan nama sheet

[Toby kenzo tobyke...@yahoo.co.id [belajar-excel]]

coba diganti:

untuk last sheet:
Set ws = Sheets(Sheets.Count)
Combobox1.Value = ws.CodeName

untuk last name sheet:

Set ws = Sheet(Sheets.Count)
Combobox1.Value = ws.Name

it's work in Office 2013 SP1.

Sent from Yahoo Mail on Android

[belajar-excel] Modifikasi Rumus IF [1 Attachment]

[Zulfikar N zulfikar_rout...@yahoo.com [belajar-excel]]

Dear Excel Master,

 Mohon bantuannya untuk memecahkan masalah rumus IF seperti file terlampir.
 

 Salam,
 Zulfikar





TOP PAGE VIEW.xlsx
Description: MS-Excel 2007 spreadsheet

Bls: Re: Re: [belajar-excel] Menarik otomatis Master Data Sesuai Data Validation

[Fahmi Syaifullah fahmisyaifulla...@yahoo.com [belajar-excel]]

Yth.mr.kid




Terima kasih mr.kid


Ternyata jika teks blank toh maksudnya.(y)






Dikirim dari Yahoo Mail pada Android


Dari:"'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" 

Tanggal:Sel, 21 Apr 2015 pada 12:56
Judul:Re: Re: [belajar-excel] Menarik otomatis Master Data Sesuai Data 
Validation


 


Hai Fahmi,


Formulasi :
right(b2:b9=i9)+(i9="")


berarti range b2:b9 bernilai sama dengan i9 atau i9 tidak ada isinya


Jadi, jika i9 ada isinya, maka yang bekerja adalah kriteria berbunyi b2:b9=i9  
yang menghasilkan baris-baris data yang nilainya sama dengan i9


jika i9 tidak ada isinya, maka yang bekerja adalah kriteria berbunyi i9="" yang 
menghasilkan seluruh baris data


Wassalam,


Kid








2015-04-21 15:39 GMT+10:00 Fahmi Syaifullah fahmisyaifulla...@yahoo.com 
[belajar-excel] :


 


Assalamualaikum wr.wb


Yth.mr.kid




Kebetulan mr. Saya mau tanya tentang rumus kolom helper yg ada di formula 
filtering data ini. Kenapa pada kolom helper ada rumus (kalau tidak salah 
seperti ini mr) small(if(right(b2:b9=i9)+(i9="") bla bla bla..


kalau tidak salah seperti itu ya mr. Yg ditanda miring mksd rumus itu apa yaa 
mr?




mhn bantuannya mr.kid


Wassalamu'alaikum wr.wb


Fahmi


Dikirim dari Yahoo Mail pada Android


Dari:"'Mr. Kid' mr.nm...@gmail.com [belajar-excel]" 

Tanggal:Sel, 21 Apr 2015 pada 10:10
Judul:Re: [belajar-excel] Menarik otomatis Master Data Sesuai Data Validation 
[1 Attachment]


 


Hai Teguh,


Filtering bisa dilakukan dengan array formula filtering seperti coretan yang 
ada disini.


File terlampir dengan cara lainnya, termasuk kemungkinan untuk menghilangkan 
kolom Total Price dari master data.


Wassalam,


Kid










2015-04-20 14:46 GMT+10:00 teguh indrawanto teguh.indrawa...@yahoo.com 
[belajar-excel] :


 


Dear Master Excel,




Bagaimana caranya untuk menarik semua data secara otomatis sesuai data 
validation yang kita pilih ?
berikut terlampir penjelasan soalnya.




Mohon bantuannya !




Atas perhatian serta bantuannya diucapkan banyak terima kasih.




Regards,




Teguh

Re: [belajar-excel] menampilkan list tanggal pada cell excel 2007

['Mr. Kid' mr.nm...@gmail.com [belajar-excel]]

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' praztm...@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
> 
> ,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..
>
>  
>

Re: [belajar-excel] ubah bentuk data tabel

['Mr. Kid' mr.nm...@gmail.com [belajar-excel]]

Maaf baru sempat nulis yang agak panjangan dikit...

Cara membuat query : silakan pelajari struktur bahasa SQL dari internet,
misalnya disini .
Jika bisa membuat query, maka akan bisa membacanya.
Jika bisa membaca query, maka akan bisa membuatnya.

Susunan umum query untuk mengambil data (menyusun dataset atau query
SELECT) :

*SELECT koloms  *

*FROM dataset_sumber *

*JOIN dataset_lookup  *
*ON kriterias_lookup*
*WHERE kriterias_filter*

*GROUP BY koloms_penyusun_grup*

*HAVING kriterias_filter_berdasar_hasil_penge-grup-an*

> bisa dijadikan urutan belajar SQL dasar <
Yang biru : harus bisa (basic)
Yang merah : diusahakan segera bisa
Yang hitam : untuk yang serius mengolah data berbasis database
Yang hijau : untuk yang suka bermain dengan pengolahan data berbasis
database

Dua part (klausa) lagi yang sebaiknya bisa, yaitu :
UNION [ALL]   -> dibaca UNION atau UNION ALL : menggabungkan data (BUKAN
menjejerkan data ya)
ORDER BY   -> mengurutkan dataset hasil

Pembuatan query dilakukan seperti pembuatan formula, dengan langkah umum :
-3 : mendefinisikan target
-2 : mendefinisikan kriteria-kriteria proses
-1 : menyusun alur proses
0 : memilih alat dan bahan proses
1 : menyusun bagian FROM
2 : menyusun bagian SELECT
3 : menyusun bagian lain dari query (bila proses memerlukannya)
4 : evaluasi query
5 : rilis kalo sudah ok

Contoh untuk kasus ini :
*-3 : mendefinisikan target*
> membentuk dataset dengan kolom-kolom : nip; nama; time; state.

*-2 : mendefinisikan kriteria-kriteria proses*
> nip dari kolom nip, nama dari kolom nama, time dari kolom tgl dan (msk
atau klr), state berupa teks yang berbunyi C/In atau C/Out
> state C/In ketika time dari tgl dan msk
> state C/Out ketika time dari tgl dan klr
> time akan berisi nilai jika kolom absen bernilai 'D', dan akan kosong
atau nol jika kolom absen bukan bernilai 'D'

*-1 : menyusun alur proses*
> a. menyusun dataset untuk state bernilai 'C/In'
> b. menyusun dataset untuk state bernilai 'C/Out'
> c. menggabungkan (BUKAN menjejerkan) hasil a dan b
> d. mengurutkan hasil c berdasar kolom nip (kolom ke-1 hasil c) secara ASC
dan state (kolom ke-4 hasil c) secara ASC

*0 : memilih alat dan bahan proses*
> menggunakan query
> sumber data dari file Excel sheet bernama cara3_data
> proses dilakukan di file Excel

*1 : menyusun bagian FROM*
> untuk proses -1.a. maupun -1.b. (karena diambil dari sumber data yang
sama)
FROM [cara3_data$] AS a
"Ambil data dari dataset bernama cara3_data yang berupa sheet Excel dan
beri nama panggilan berbunyi 'a' "

*2 : menyusun bagian SELECT (sumber data diberi nama panggilan a)*
> untuk proses -1.a.
SELECT a.nip, a.nama
 ,cdate(format(clng(a.tgl),'-00-00')+'
'+left(a.msk,2)+':'+right(a.msk,2)),0) as [time]
 ,'C/In' as [state]
"susun dataset kolom dari kolom nip sumber data a, kolom nama dari sumber
data a, ketika kolom absen dari sumber data a bernilai 'D', susun data
datetime dari kolom tgl ditambah waktu berupa susunan 2 karakter terkiri
kolom msk dihubungkan titik dua (:) diikuti 2 karakter terkanan kolom msk
dan kolom ini diberi nama panggilan time, kolom dengan nama panggilan state
diisi dengan teks tetap (constant text alias string) berbunyi C/In"

> untuk proses -1.b.
SELECT a.nip, a.nama
 ,cdate(format(clng(a.tgl),'-00-00')+'
'+left(a.klr,2)+':'+right(a.klr,2)),0) as [time]
 ,'C/Out' as [state]
"susun dataset kolom dari kolom nip sumber data a, kolom nama dari sumber
data a, ketika kolom absen dari sumber data a bernilai 'D', susun data
datetime dari kolom tgl ditambah waktu berupa susunan 2 karakter terkiri
kolom klr dihubungkan titik dua (:) diikuti 2 karakter terkanan kolom klr
dan kolom ini diberi nama panggilan time, kolom dengan nama panggilan state
diisi dengan teks tetap (constant text alias string) berbunyi C/Out"

*3 : menyusun bagian lain dari query (bila proses memerlukannya)*
> dengan susunan dasar query SELECT seperti yang diberi warna warni di
atas, maka susunan proses 1 dan 2 menjadi :
   - proses -1.a.
SELECT a.nip, a.nama
 ,cdate(format(clng(a.tgl),'-00-00')+'
'+left(a.msk,2)+':'+right(a.msk,2)),0) as [time]
 ,'C/In' as [state]
FROM [cara3_data$] AS a

  - proses -1.b.
SELECT a.nip, a.nama
 ,cdate(format(clng(a.tgl),'-00-00')+'
'+left(a.klr,2)+':'+right(a.klr,2)),0) as [time]
 ,'C/Out' as [state]
FROM [cara3_data$] AS a

> proses -1.c., yaitu menggabungkan hasil a dan b dengan memanfaatkan
klausa UNION ALL

SELECT a.nip, a.nama
 ,cdate(format(clng(a.tgl),'-00-00')+'
'+left(a.msk,2)+':'+right(a.msk,2)),0) as [time]
 ,'C/In' as [state]
FROM [cara3_data$] AS a

UNION ALL

SELECT a.nip, a.nama
 ,cdate(format(clng(a.tgl),'-00-00')+'
'+left(a.klr,2)+':'+right(a.klr,2)),0) as [time]
 ,'C/Out' as [state]
FROM [cara3_data$] AS a

> proses -1.d., mengurutkan hasil dengan klausa ORDER BY berdasar kolom
ke-1 ASC dan kolom ke-4 ASC
ORDER BY 1 ASC, 4 ASC
--> karena default ORDER BY adalah ASC, maka bisa ditulis :

Re: [belajar-excel] Modifikasi Rumus IF [1 Attachment]

[Nang Agus nanga...@gmail.com [belajar-excel]]

saya menggunakan kolom bantu untuk sisi data

=INDEX($B$4:$B$16,MATCH(LARGE($D$4:$D$16,E4),$D$4:$D$16,0))

2015-04-21 17:27 GMT+07:00 Zulfikar N zulfikar_rout...@yahoo.com
[belajar-excel] :

>
>
> Dear Excel Master,
> Mohon bantuannya untuk memecahkan masalah rumus IF seperti file terlampir.
>
> Salam,
> Zulfikar
>
>  
>


TOP PAGE VIEW.xlsx
Description: MS-Excel 2007 spreadsheet

[belajar-excel] Menampilkan data berdasar kriteria [1 Attachment]

[heru mulyono hmulyon...@gmail.com [belajar-excel]]

Yth, Master Excel
Mohon Bantuan permasalahan saya,


file terlampir
Terimakasih


Menampilkan data dengan kriteria.xlsx
Description: MS-Excel 2007 spreadsheet

[belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad [1 Attachment]

[Zerlinda Seismica seism...@yahoo.com [belajar-excel]]

Assalamualaikum wrwb
Sebelumnya terima kasih buat Mas Kid dan Mas Hendrik atas solusi 
kemrin...semoga tidak bosen lagi untuk memberi pencerahan...Problemnya adalah 
menampilkan angka nol didepan angka asli..solusi saya pake tanda kutip tapi 
jadi text padahal saya ingin number.Yang kedua data dari excel dicopy paste ke 
notepad/textpad tp harus ada spasi tertentu..untuk detailnya saya kirimkan 
kadonya...ITu aja...semoga tetep diberi semangat


Wassalam wrwbSeismica


Menampilkan Angka Nol dan CopyPaste ke Notepad.xlsx
Description: MS-Excel 2007 spreadsheet

Re: [belajar-excel] Memunculkan nama sheet

[danny_06...@yahoo.com [belajar-excel]]

Terima kasih sebelumnya. Kode yg diberikan semuanya berhasil. Sekali lagi 
terima kasih :)

Bls: [belajar-excel] Cara Membuat Data dengan Baris Berurut

[Zerlinda Seismica seism...@yahoo.com [belajar-excel]]

Alhamdulila lagi...closed problemsuwun sangett buat Mas Kid dan Mas 
Hendrik...Ada tambahan lagi diiimel berikutnya hehe...Salam Seismica





 Pada Selasa, 21 April 2015 14:17, "hendrik karnadi 
hendrikkarn...@yahoo.com [belajar-excel]"  
menulis:



 #yiv7957795189 #yiv7957795189 -- #yiv7957795189 
.yiv7957795189ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv7957795189
 
div.yiv7957795189ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
 solid black;height:62px;width:62px;}#yiv7957795189 
div.yiv7957795189photo-title a, #yiv7957795189 div.yiv7957795189photo-title 
a:active, #yiv7957795189 div.yiv7957795189photo-title a:hover, #yiv7957795189 
div.yiv7957795189photo-title a:visited {text-decoration:none;}#yiv7957795189 
div.yiv7957795189attach-table div.yiv7957795189attach-row 
{clear:both;}#yiv7957795189 div.yiv7957795189attach-table 
div.yiv7957795189attach-row div {float:left;}#yiv7957795189 p 
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv7957795189 
div.yiv7957795189ygrp-file {width:30px;}#yiv7957795189 
div.yiv7957795189attach-table div.yiv7957795189attach-row div div a 
{text-decoration:none;}#yiv7957795189 div.yiv7957795189attach-table 
div.yiv7957795189attach-row div div span {font-weight:normal;}#yiv7957795189 
div.yiv7957795189ygrp-file-title {font-weight:bold;}#yiv7957795189 
#yiv7957795189


Hai Seismica,Coba pakai kolom bantu disamping Inputnya dan gunakan fungsi 
Vlookup untuk Hasilnya, dengan memakai kolom bantu tersebut sebagai Lookup 
Value.File jawaban terlampir.
Salam,HK
  From: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" 

 To: belajar-excel@yahoogroups.com
 Sent: Tuesday, 21 April 2015, 8:17
 Subject: [belajar-excel] Cara Membuat Data dengan Baris Berurut [1 Attachment]

    Assalamu'alaikum wrwbMohon bantuan lagi para master...Cara Membuat Data 
dengan Baris Berurut seperti contoh terlampir..:)WassalamSeismica
   #yiv7957795189 -- #yiv7957795189ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7957795189 
#yiv7957795189ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7957795189 
#yiv7957795189ygrp-mkp #yiv7957795189hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7957795189 #yiv7957795189ygrp-mkp #yiv7957795189ads 
{margin-bottom:10px;}#yiv7957795189 #yiv7957795189ygrp-mkp .yiv7957795189ad 
{padding:0 0;}#yiv7957795189 #yiv7957795189ygrp-mkp .yiv7957795189ad p 
{margin:0;}#yiv7957795189 #yiv7957795189ygrp-mkp .yiv7957795189ad a 
{color:#ff;text-decoration:none;}#yiv7957795189 #yiv7957795189ygrp-sponsor 
#yiv7957795189ygrp-lc {font-family:Arial;}#yiv7957795189 
#yiv7957795189ygrp-sponsor #yiv7957795189ygrp-lc #yiv7957795189hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7957795189 
#yiv7957795189ygrp-sponsor #yiv7957795189ygrp-lc .yiv7957795189ad 
{margin-bottom:10px;padding:0 0;}#yiv7957795189 #yiv7957795189actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7957795189 
#yiv7957795189activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7957795189
 #yiv7957795189activity span {font-weight:700;}#yiv7957795189 
#yiv7957795189activity span:first-child 
{text-transform:uppercase;}#yiv7957795189 #yiv7957795189activity span a 
{color:#5085b6;text-decoration:none;}#yiv7957795189 #yiv7957795189activity span 
span {color:#ff7900;}#yiv7957795189 #yiv7957795189activity span 
.yiv7957795189underline {text-decoration:underline;}#yiv7957795189 
.yiv7957795189attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7957795189 .yiv7957795189attach div a 
{text-decoration:none;}#yiv7957795189 .yiv7957795189attach img 
{border:none;padding-right:5px;}#yiv7957795189 .yiv7957795189attach label 
{display:block;margin-bottom:5px;}#yiv7957795189 .yiv7957795189attach label a 
{text-decoration:none;}#yiv7957795189 blockquote {margin:0 0 0 
4px;}#yiv7957795189 .yiv7957795189bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7957795189 
.yiv7957795189bold a {text-decoration:none;}#yiv7957795189 dd.yiv7957795189last 
p a {font-family:Verdana;font-weight:700;}#yiv7957795189 dd.yiv7957795189last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7957795189 
dd.yiv7957795189last p span.yiv7957795189yshortcuts 
{margin-right:0;}#yiv7957795189 div.yiv7957795189attach-table div div a 
{text-decoration:none;}#yiv7957795189 div.yiv7957795189attach-table 
{width:400px;}#yiv7957795189 div.yiv7957795189file-title a, #yiv7957795189 
div.yiv7957795189file-title a:active, #yiv7957795189 
div.yiv7957795189file-title a:hover, #yiv7957795189  
div.yiv7957795189file-title a:visited {text-decoration:none;}#yiv7957795189 
div.yiv7957795189photo-title a, #yiv7957795189 div.yiv7957795189photo-title 
a:active, #yiv7957795189 div.yiv7957795189photo-title a:hover, #yiv7

Re: [belajar-excel] jurnal mutasi bank

[Wewith Isme wewithi...@ymail.com [belajar-excel]]

Dear Para Master,Mohon pencerahannyaTrims








 On Thursday, 9 April 2015, 13:51, "Wewith Isme wewithi...@ymail.com 
[belajar-excel]"  wrote:



     Dear Para Master,Tolong bantuannya perihal kasus berikut,"Jurnal Mutasi 
Bank" Bagaimanakah rumus untuk membuat jurnal secara otomatis dariData/Sumber 
(terlampir)berdasarkan database (terlampir) pada masing-masing bank (terlampir) 
Mohon pencerahannya Terima KasihWewith
  #yiv7436525133 #yiv7436525133 -- #yiv7436525133ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7436525133 
#yiv7436525133ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7436525133 
#yiv7436525133ygrp-mkp #yiv7436525133hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7436525133 #yiv7436525133ygrp-mkp #yiv7436525133ads 
{margin-bottom:10px;}#yiv7436525133 #yiv7436525133ygrp-mkp .yiv7436525133ad 
{padding:0 0;}#yiv7436525133 #yiv7436525133ygrp-mkp .yiv7436525133ad p 
{margin:0;}#yiv7436525133 #yiv7436525133ygrp-mkp .yiv7436525133ad a 
{color:#ff;text-decoration:none;}#yiv7436525133 #yiv7436525133ygrp-sponsor 
#yiv7436525133ygrp-lc {font-family:Arial;}#yiv7436525133 
#yiv7436525133ygrp-sponsor #yiv7436525133ygrp-lc #yiv7436525133hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7436525133 
#yiv7436525133ygrp-sponsor #yiv7436525133ygrp-lc .yiv7436525133ad 
{margin-bottom:10px;padding:0 0;}#yiv7436525133 #yiv7436525133actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7436525133 
#yiv7436525133activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7436525133
 #yiv7436525133activity span {font-weight:700;}#yiv7436525133 
#yiv7436525133activity span:first-child 
{text-transform:uppercase;}#yiv7436525133 #yiv7436525133activity span a 
{color:#5085b6;text-decoration:none;}#yiv7436525133 #yiv7436525133activity span 
span {color:#ff7900;}#yiv7436525133 #yiv7436525133activity span 
.yiv7436525133underline {text-decoration:underline;}#yiv7436525133 
.yiv7436525133attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7436525133 .yiv7436525133attach div a 
{text-decoration:none;}#yiv7436525133 .yiv7436525133attach img 
{border:none;padding-right:5px;}#yiv7436525133 .yiv7436525133attach label 
{display:block;margin-bottom:5px;}#yiv7436525133 .yiv7436525133attach label a 
{text-decoration:none;}#yiv7436525133 blockquote {margin:0 0 0 
4px;}#yiv7436525133 .yiv7436525133bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7436525133 
.yiv7436525133bold a {text-decoration:none;}#yiv7436525133 dd.yiv7436525133last 
p a {font-family:Verdana;font-weight:700;}#yiv7436525133 dd.yiv7436525133last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7436525133 
dd.yiv7436525133last p span.yiv7436525133yshortcuts 
{margin-right:0;}#yiv7436525133 div.yiv7436525133attach-table div div a 
{text-decoration:none;}#yiv7436525133 div.yiv7436525133attach-table 
{width:400px;}#yiv7436525133 div.yiv7436525133file-title a, #yiv7436525133 
div.yiv7436525133file-title a:active, #yiv7436525133 
div.yiv7436525133file-title a:hover, #yiv7436525133 div.yiv7436525133file-title 
a:visited {text-decoration:none;}#yiv7436525133 div.yiv7436525133photo-title a, 
#yiv7436525133 div.yiv7436525133photo-title a:active, #yiv7436525133 
div.yiv7436525133photo-title a:hover, #yiv7436525133 
div.yiv7436525133photo-title a:visited {text-decoration:none;}#yiv7436525133 
div#yiv7436525133ygrp-mlmsg #yiv7436525133ygrp-msg p a 
span.yiv7436525133yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7436525133 
.yiv7436525133green {color:#628c2a;}#yiv7436525133 .yiv7436525133MsoNormal 
{margin:0 0 0 0;}#yiv7436525133 o {font-size:0;}#yiv7436525133 
#yiv7436525133photos div {float:left;width:72px;}#yiv7436525133 
#yiv7436525133photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv7436525133 
#yiv7436525133photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7436525133
 #yiv7436525133reco-category {font-size:77%;}#yiv7436525133 
#yiv7436525133reco-desc {font-size:77%;}#yiv7436525133 .yiv7436525133replbq 
{margin:4px;}#yiv7436525133 #yiv7436525133ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv7436525133 #yiv7436525133ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7436525133 
#yiv7436525133ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7436525133 
#yiv7436525133ygrp-mlmsg select, #yiv7436525133 input, #yiv7436525133 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7436525133 
#yiv7436525133ygrp-mlmsg pre, #yiv7436525133 code {font:115% 
monospace;}#yiv7436525133 #yiv7436525133ygrp-mlmsg * 
{line-height:1.22em;}#yiv7436525133 #yiv7436525133ygrp-mlmsg #yiv7436525133logo 
{padding-bottom:10px;}#yiv7436525133 #yiv7436525133ygrp-msg p a 
{font-famil

[belajar-excel] Cara Meranking berdasarkan kelompok posisi [1 Attachment]

[Eko Budhi eko_tbr...@yahoo.com [belajar-excel]]

Yth pakar2 B-Excel,
Mohon bantuan nya utk membuat ranking tapi berdasarkan posisi sesuai lampiran, 
acuanya ada di kolom D & C. sebelum dan sesudahnya saya sampaikan terimakasih 
kasih banyak atas ilmunya

Salam,
Eko

Cara Ranking Berdasarkan Posisi.xlsx
Description: MS-Excel 2007 spreadsheet

Re: [belajar-excel] jurnal mutasi bank

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Hai Wewith,Lampirannya koq ga ada?
Salam,HK
  From: "Wewith Isme wewithi...@ymail.com [belajar-excel]" 

 To: belajar-excel@yahoogroups.com 
 Sent: Wednesday, 22 April 2015, 9:49
 Subject: Re: [belajar-excel] jurnal mutasi bank
   
    Dear Para Master,Mohon pencerahannyaTrims




 On Thursday, 9 April 2015, 13:51, "Wewith Isme wewithi...@ymail.com 
[belajar-excel]"  wrote:
   

     Dear Para Master,Tolong bantuannya perihal kasus berikut,"Jurnal Mutasi 
Bank" Bagaimanakah rumus untuk membuat jurnal secara otomatis dariData/Sumber 
(terlampir)berdasarkan database (terlampir) pada masing-masing bank (terlampir) 
Mohon pencerahannya Terima KasihWewith
  

 #yiv1603430170 #yiv1603430170 -- #yiv1603430170ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1603430170 
#yiv1603430170ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1603430170 
#yiv1603430170ygrp-mkp #yiv1603430170hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1603430170 #yiv1603430170ygrp-mkp #yiv1603430170ads 
{margin-bottom:10px;}#yiv1603430170 #yiv1603430170ygrp-mkp .yiv1603430170ad 
{padding:0 0;}#yiv1603430170 #yiv1603430170ygrp-mkp .yiv1603430170ad p 
{margin:0;}#yiv1603430170 #yiv1603430170ygrp-mkp .yiv1603430170ad a 
{color:#ff;text-decoration:none;}#yiv1603430170 #yiv1603430170ygrp-sponsor 
#yiv1603430170ygrp-lc {font-family:Arial;}#yiv1603430170 
#yiv1603430170ygrp-sponsor #yiv1603430170ygrp-lc #yiv1603430170hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1603430170 
#yiv1603430170ygrp-sponsor #yiv1603430170ygrp-lc .yiv1603430170ad 
{margin-bottom:10px;padding:0 0;}#yiv1603430170 #yiv1603430170actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1603430170 
#yiv1603430170activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1603430170
 #yiv1603430170activity span {font-weight:700;}#yiv1603430170 
#yiv1603430170activity span:first-child 
{text-transform:uppercase;}#yiv1603430170 #yiv1603430170activity span a 
{color:#5085b6;text-decoration:none;}#yiv1603430170 #yiv1603430170activity span 
span {color:#ff7900;}#yiv1603430170 #yiv1603430170activity span 
.yiv1603430170underline {text-decoration:underline;}#yiv1603430170 
.yiv1603430170attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1603430170 .yiv1603430170attach div a 
{text-decoration:none;}#yiv1603430170 .yiv1603430170attach img 
{border:none;padding-right:5px;}#yiv1603430170 .yiv1603430170attach label 
{display:block;margin-bottom:5px;}#yiv1603430170 .yiv1603430170attach label a 
{text-decoration:none;}#yiv1603430170 blockquote {margin:0 0 0 
4px;}#yiv1603430170 .yiv1603430170bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1603430170 
.yiv1603430170bold a {text-decoration:none;}#yiv1603430170 dd.yiv1603430170last 
p a {font-family:Verdana;font-weight:700;}#yiv1603430170 dd.yiv1603430170last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1603430170 
dd.yiv1603430170last p span.yiv1603430170yshortcuts 
{margin-right:0;}#yiv1603430170 div.yiv1603430170attach-table div div a 
{text-decoration:none;}#yiv1603430170 div.yiv1603430170attach-table 
{width:400px;}#yiv1603430170 div.yiv1603430170file-title a, #yiv1603430170 
div.yiv1603430170file-title a:active, #yiv1603430170 
div.yiv1603430170file-title a:hover, #yiv1603430170 div.yiv1603430170file-title 
a:visited {text-decoration:none;}#yiv1603430170 div.yiv1603430170photo-title a, 
#yiv1603430170 div.yiv1603430170photo-title a:active, #yiv1603430170 
div.yiv1603430170photo-title a:hover, #yiv1603430170 
div.yiv1603430170photo-title a:visited {text-decoration:none;}#yiv1603430170 
div#yiv1603430170ygrp-mlmsg #yiv1603430170ygrp-msg p a 
span.yiv1603430170yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1603430170 
.yiv1603430170green {color:#628c2a;}#yiv1603430170 .yiv1603430170MsoNormal 
{margin:0 0 0 0;}#yiv1603430170 o {font-size:0;}#yiv1603430170 
#yiv1603430170photos div {float:left;width:72px;}#yiv1603430170 
#yiv1603430170photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv1603430170 
#yiv1603430170photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1603430170
 #yiv1603430170reco-category {font-size:77%;}#yiv1603430170 
#yiv1603430170reco-desc {font-size:77%;}#yiv1603430170 .yiv1603430170replbq 
{margin:4px;}#yiv1603430170 #yiv1603430170ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv1603430170 #yiv1603430170ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1603430170 
#yiv1603430170ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1603430170 
#yiv1603430170ygrp-mlmsg select, #yiv1603430170 input, #yiv1603430170 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv1603430170 
#yiv1603430170ygrp-mlmsg pre

Re: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Hai Seismica,
Jawaban atas pertanyaan pertama... kayaknya ga bisa.
Jawaban atas pertanyaan kedua:=A5&REPT(" ",10)&B5&REPT(" ",10)&C5

Salam,HK

  From: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" 

 To: belajar-excel@yahoogroups.com 
 Sent: Wednesday, 22 April 2015, 9:17
 Subject: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad [1 
Attachment]
   
    Assalamualaikum wrwb
Sebelumnya terima kasih buat Mas Kid dan Mas Hendrik atas solusi 
kemrin...semoga tidak bosen lagi untuk memberi pencerahan...Problemnya adalah 
menampilkan angka nol didepan angka asli..solusi saya pake tanda kutip tapi 
jadi text padahal saya ingin number.Yang kedua data dari excel dicopy paste ke 
notepad/textpad tp harus ada spasi tertentu..untuk detailnya saya kirimkan 
kadonya...ITu aja...semoga tetep diberi semangat

Wassalam wrwbSeismica
  #yiv3795287868 #yiv3795287868 -- #yiv3795287868ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3795287868 
#yiv3795287868ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3795287868 
#yiv3795287868ygrp-mkp #yiv3795287868hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3795287868 #yiv3795287868ygrp-mkp #yiv3795287868ads 
{margin-bottom:10px;}#yiv3795287868 #yiv3795287868ygrp-mkp .yiv3795287868ad 
{padding:0 0;}#yiv3795287868 #yiv3795287868ygrp-mkp .yiv3795287868ad p 
{margin:0;}#yiv3795287868 #yiv3795287868ygrp-mkp .yiv3795287868ad a 
{color:#ff;text-decoration:none;}#yiv3795287868 #yiv3795287868ygrp-sponsor 
#yiv3795287868ygrp-lc {font-family:Arial;}#yiv3795287868 
#yiv3795287868ygrp-sponsor #yiv3795287868ygrp-lc #yiv3795287868hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3795287868 
#yiv3795287868ygrp-sponsor #yiv3795287868ygrp-lc .yiv3795287868ad 
{margin-bottom:10px;padding:0 0;}#yiv3795287868 #yiv3795287868actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3795287868 
#yiv3795287868activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3795287868
 #yiv3795287868activity span {font-weight:700;}#yiv3795287868 
#yiv3795287868activity span:first-child 
{text-transform:uppercase;}#yiv3795287868 #yiv3795287868activity span a 
{color:#5085b6;text-decoration:none;}#yiv3795287868 #yiv3795287868activity span 
span {color:#ff7900;}#yiv3795287868 #yiv3795287868activity span 
.yiv3795287868underline {text-decoration:underline;}#yiv3795287868 
.yiv3795287868attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3795287868 .yiv3795287868attach div a 
{text-decoration:none;}#yiv3795287868 .yiv3795287868attach img 
{border:none;padding-right:5px;}#yiv3795287868 .yiv3795287868attach label 
{display:block;margin-bottom:5px;}#yiv3795287868 .yiv3795287868attach label a 
{text-decoration:none;}#yiv3795287868 blockquote {margin:0 0 0 
4px;}#yiv3795287868 .yiv3795287868bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3795287868 
.yiv3795287868bold a {text-decoration:none;}#yiv3795287868 dd.yiv3795287868last 
p a {font-family:Verdana;font-weight:700;}#yiv3795287868 dd.yiv3795287868last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3795287868 
dd.yiv3795287868last p span.yiv3795287868yshortcuts 
{margin-right:0;}#yiv3795287868 div.yiv3795287868attach-table div div a 
{text-decoration:none;}#yiv3795287868 div.yiv3795287868attach-table 
{width:400px;}#yiv3795287868 div.yiv3795287868file-title a, #yiv3795287868 
div.yiv3795287868file-title a:active, #yiv3795287868 
div.yiv3795287868file-title a:hover, #yiv3795287868 div.yiv3795287868file-title 
a:visited {text-decoration:none;}#yiv3795287868 div.yiv3795287868photo-title a, 
#yiv3795287868 div.yiv3795287868photo-title a:active, #yiv3795287868 
div.yiv3795287868photo-title a:hover, #yiv3795287868 
div.yiv3795287868photo-title a:visited {text-decoration:none;}#yiv3795287868 
div#yiv3795287868ygrp-mlmsg #yiv3795287868ygrp-msg p a 
span.yiv3795287868yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3795287868 
.yiv3795287868green {color:#628c2a;}#yiv3795287868 .yiv3795287868MsoNormal 
{margin:0 0 0 0;}#yiv3795287868 o {font-size:0;}#yiv3795287868 
#yiv3795287868photos div {float:left;width:72px;}#yiv3795287868 
#yiv3795287868photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv3795287868 
#yiv3795287868photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3795287868
 #yiv3795287868reco-category {font-size:77%;}#yiv3795287868 
#yiv3795287868reco-desc {font-size:77%;}#yiv3795287868 .yiv3795287868replbq 
{margin:4px;}#yiv3795287868 #yiv3795287868ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv3795287868 #yiv3795287868ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3795287868 
#yiv3795287868ygrp-mlmsg table {font-size:inherit;font:100%;}#y

Fw: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Jawaban kedua harus dicopas value dulu
Salam,HK
- Forwarded Message -
  From: "hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]" 

 To: "belajar-excel@yahoogroups.com"  
 Sent: Wednesday, 22 April 2015, 10:51
 Subject: Re: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad
   
    Hai Seismica,
Jawaban atas pertanyaan pertama... kayaknya ga bisa.
Jawaban atas pertanyaan kedua:=A5&REPT(" ",10)&B5&REPT(" ",10)&C5

Salam,HK

  From: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" 

 To: belajar-excel@yahoogroups.com 
 Sent: Wednesday, 22 April 2015, 9:17
 Subject: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad [1 
Attachment]
   
    Assalamualaikum wrwb
Sebelumnya terima kasih buat Mas Kid dan Mas Hendrik atas solusi 
kemrin...semoga tidak bosen lagi untuk memberi pencerahan...Problemnya adalah 
menampilkan angka nol didepan angka asli..solusi saya pake tanda kutip tapi 
jadi text padahal saya ingin number.Yang kedua data dari excel dicopy paste ke 
notepad/textpad tp harus ada spasi tertentu..untuk detailnya saya kirimkan 
kadonya...ITu aja...semoga tetep diberi semangat

Wassalam wrwbSeismica
  

 #yiv6545788072 #yiv6545788072 -- #yiv6545788072ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6545788072 
#yiv6545788072ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6545788072 
#yiv6545788072ygrp-mkp #yiv6545788072hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv6545788072 #yiv6545788072ygrp-mkp #yiv6545788072ads 
{margin-bottom:10px;}#yiv6545788072 #yiv6545788072ygrp-mkp .yiv6545788072ad 
{padding:0 0;}#yiv6545788072 #yiv6545788072ygrp-mkp .yiv6545788072ad p 
{margin:0;}#yiv6545788072 #yiv6545788072ygrp-mkp .yiv6545788072ad a 
{color:#ff;text-decoration:none;}#yiv6545788072 #yiv6545788072ygrp-sponsor 
#yiv6545788072ygrp-lc {font-family:Arial;}#yiv6545788072 
#yiv6545788072ygrp-sponsor #yiv6545788072ygrp-lc #yiv6545788072hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6545788072 
#yiv6545788072ygrp-sponsor #yiv6545788072ygrp-lc .yiv6545788072ad 
{margin-bottom:10px;padding:0 0;}#yiv6545788072 #yiv6545788072actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6545788072 
#yiv6545788072activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6545788072
 #yiv6545788072activity span {font-weight:700;}#yiv6545788072 
#yiv6545788072activity span:first-child 
{text-transform:uppercase;}#yiv6545788072 #yiv6545788072activity span a 
{color:#5085b6;text-decoration:none;}#yiv6545788072 #yiv6545788072activity span 
span {color:#ff7900;}#yiv6545788072 #yiv6545788072activity span 
.yiv6545788072underline {text-decoration:underline;}#yiv6545788072 
.yiv6545788072attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv6545788072 .yiv6545788072attach div a 
{text-decoration:none;}#yiv6545788072 .yiv6545788072attach img 
{border:none;padding-right:5px;}#yiv6545788072 .yiv6545788072attach label 
{display:block;margin-bottom:5px;}#yiv6545788072 .yiv6545788072attach label a 
{text-decoration:none;}#yiv6545788072 blockquote {margin:0 0 0 
4px;}#yiv6545788072 .yiv6545788072bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6545788072 
.yiv6545788072bold a {text-decoration:none;}#yiv6545788072 dd.yiv6545788072last 
p a {font-family:Verdana;font-weight:700;}#yiv6545788072 dd.yiv6545788072last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6545788072 
dd.yiv6545788072last p span.yiv6545788072yshortcuts 
{margin-right:0;}#yiv6545788072 div.yiv6545788072attach-table div div a 
{text-decoration:none;}#yiv6545788072 div.yiv6545788072attach-table 
{width:400px;}#yiv6545788072 div.yiv6545788072file-title a, #yiv6545788072 
div.yiv6545788072file-title a:active, #yiv6545788072 
div.yiv6545788072file-title a:hover, #yiv6545788072 div.yiv6545788072file-title 
a:visited {text-decoration:none;}#yiv6545788072 div.yiv6545788072photo-title a, 
#yiv6545788072 div.yiv6545788072photo-title a:active, #yiv6545788072 
div.yiv6545788072photo-title a:hover, #yiv6545788072 
div.yiv6545788072photo-title a:visited {text-decoration:none;}#yiv6545788072 
div#yiv6545788072ygrp-mlmsg #yiv6545788072ygrp-msg p a 
span.yiv6545788072yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6545788072 
.yiv6545788072green {color:#628c2a;}#yiv6545788072 .yiv6545788072MsoNormal 
{margin:0 0 0 0;}#yiv6545788072 o {font-size:0;}#yiv6545788072 
#yiv6545788072photos div {float:left;width:72px;}#yiv6545788072 
#yiv6545788072photos div div {border:1px solid 
#66;height:62px;overflow:hidden;width:62px;}#yiv6545788072 
#yiv6545788072photos div label 
{color:#66;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6545788072
 #yiv6545788072reco-category {font-size:77%;}#yiv6545788072 
#yiv6545788072reco-desc {font-size:77%;}#yiv654

Fw: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Karena saya ga punya notepad, saya copas ke word tanpa di copas value terlebih 
dahulu...ternyata hasilnya langsung value.
Salam,HK

- Forwarded Message -
  From: hendrik karnadi 
 To: "belajar-excel@yahoogroups.com"  
 Sent: Wednesday, 22 April 2015, 10:55
 Subject: Fw: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad
   
Jawaban kedua harus dicopas value dulu
Salam,HK
   

 - Forwarded Message -
  From: "hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]" 

 To: "belajar-excel@yahoogroups.com"  
 Sent: Wednesday, 22 April 2015, 10:51
 Subject: Re: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad
   
    Hai Seismica,
Jawaban atas pertanyaan pertama... kayaknya ga bisa.
Jawaban atas pertanyaan kedua:=A5&REPT(" ",10)&B5&REPT(" ",10)&C5

Salam,HK

  From: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" 

 To: belajar-excel@yahoogroups.com 
 Sent: Wednesday, 22 April 2015, 9:17
 Subject: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad [1 
Attachment]
   
    Assalamualaikum wrwb
Sebelumnya terima kasih buat Mas Kid dan Mas Hendrik atas solusi 
kemrin...semoga tidak bosen lagi untuk memberi pencerahan...Problemnya adalah 
menampilkan angka nol didepan angka asli..solusi saya pake tanda kutip tapi 
jadi text padahal saya ingin number.Yang kedua data dari excel dicopy paste ke 
notepad/textpad tp harus ada spasi tertentu..untuk detailnya saya kirimkan 
kadonya...ITu aja...semoga tetep diberi semangat

Wassalam wrwbSeismica
  

 #yiv3762872534 -- #yiv3762872534ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3762872534 
#yiv3762872534ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3762872534 
#yiv3762872534ygrp-mkp #yiv3762872534hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv3762872534 #yiv3762872534ygrp-mkp #yiv3762872534ads 
{margin-bottom:10px;}#yiv3762872534 #yiv3762872534ygrp-mkp .yiv3762872534ad 
{padding:0 0;}#yiv3762872534 #yiv3762872534ygrp-mkp .yiv3762872534ad p 
{margin:0;}#yiv3762872534 #yiv3762872534ygrp-mkp .yiv3762872534ad a 
{color:#ff;text-decoration:none;}#yiv3762872534 #yiv3762872534ygrp-sponsor 
#yiv3762872534ygrp-lc {font-family:Arial;}#yiv3762872534 
#yiv3762872534ygrp-sponsor #yiv3762872534ygrp-lc #yiv3762872534hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3762872534 
#yiv3762872534ygrp-sponsor #yiv3762872534ygrp-lc .yiv3762872534ad 
{margin-bottom:10px;padding:0 0;}#yiv3762872534 #yiv3762872534actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3762872534 
#yiv3762872534activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3762872534
 #yiv3762872534activity span {font-weight:700;}#yiv3762872534 
#yiv3762872534activity span:first-child 
{text-transform:uppercase;}#yiv3762872534 #yiv3762872534activity span a 
{color:#5085b6;text-decoration:none;}#yiv3762872534 #yiv3762872534activity span 
span {color:#ff7900;}#yiv3762872534 #yiv3762872534activity span 
.yiv3762872534underline {text-decoration:underline;}#yiv3762872534 
.yiv3762872534attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv3762872534 .yiv3762872534attach div a 
{text-decoration:none;}#yiv3762872534 .yiv3762872534attach img 
{border:none;padding-right:5px;}#yiv3762872534 .yiv3762872534attach label 
{display:block;margin-bottom:5px;}#yiv3762872534 .yiv3762872534attach label a 
{text-decoration:none;}#yiv3762872534 blockquote {margin:0 0 0 
4px;}#yiv3762872534 .yiv3762872534bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3762872534 
.yiv3762872534bold a {text-decoration:none;}#yiv3762872534 dd.yiv3762872534last 
p a {font-family:Verdana;font-weight:700;}#yiv3762872534 dd.yiv3762872534last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3762872534 
dd.yiv3762872534last p span.yiv3762872534yshortcuts 
{margin-right:0;}#yiv3762872534 div.yiv3762872534attach-table div div a 
{text-decoration:none;}#yiv3762872534 div.yiv3762872534attach-table 
{width:400px;}#yiv3762872534 div.yiv3762872534file-title a, #yiv3762872534 
div.yiv3762872534file-title a:active, #yiv3762872534 
div.yiv3762872534file-title a:hover, #yiv3762872534 div.yiv3762872534file-title 
a:visited {text-decoration:none;}#yiv3762872534 div.yiv3762872534photo-title a, 
#yiv3762872534 div.yiv3762872534photo-title a:active, #yiv3762872534 
div.yiv3762872534photo-title a:hover, #yiv3762872534 
div.yiv3762872534photo-title a:visited {text-decoration:none;}#yiv3762872534 
div#yiv3762872534ygrp-mlmsg #yiv3762872534ygrp-msg p a 
span.yiv3762872534yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3762872534 
.yiv3762872534green {color:#628c2a;}#yiv3762872534 .yiv3762872534MsoNormal 
{margin:0 0 0 0;}#yiv3762872534 o {font-size:0;}#yiv3762872534 
#yiv3762872534photos div {float:left;width:72px;}#yiv3762872534 
#yiv3762872534photos div

RE: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

[Dede pmaho_l...@nabatisnack.co.id [belajar-excel]]

Ikutan yah...

 

Mungkin untuk pertanyaan pertama bisa dicoba dengan cara :

Block range cell C5:C7  à Format Cells à Custom à Type isi dengan  #.000

 

Semoga sesuai harapan.

 

Salam,

DD

From: hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] 
[mailto:belajar-excel@yahoogroups.com] 
Sent: 22 April 2015 10:51
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

 

  

Hai Seismica,

 

Jawaban atas pertanyaan pertama... kayaknya ga bisa.

 

Jawaban atas pertanyaan kedua:

=A5&REPT(" ",10)&B5&REPT(" ",10)&C5

 

Salam,

HK

 

 

  _  

From: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" 

To: belajar-excel@yahoogroups.com 
Sent: Wednesday, 22 April 2015, 9:17
Subject: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad [1 
Attachment]

 

  

Assalamualaikum wrwb

 

Sebelumnya terima kasih buat Mas Kid dan Mas Hendrik atas solusi 
kemrin...semoga tidak bosen lagi untuk memberi pencerahan...

Problemnya adalah menampilkan angka nol didepan angka asli..solusi saya pake 
tanda kutip tapi jadi text padahal saya ingin number.

Yang kedua data dari excel dicopy paste ke notepad/textpad tp harus ada spasi 
tertentu..untuk detailnya saya kirimkan kadonya...

ITu aja...semoga tetep diberi semangat

 

 

Wassalam wrwb

Seismica

 



 

  _  

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.

RE: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

[Dede pmaho_l...@nabatisnack.co.id [belajar-excel]]

Oh iya formulanya akan mengalami sedikit perubahan menjadi :

=A5&REPT(" ";10)&B5&REPT(" ";10)&TEXT(C5;"000")

Ambil dari formula Mr HK.

 

Salam,

DD

 

From: Dede pmaho_l...@nabatisnack.co.id [belajar-excel] 
[mailto:belajar-excel@yahoogroups.com] 
Sent: 22 April 2015 11:38
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

 

  

Ikutan yah...

 

Mungkin untuk pertanyaan pertama bisa dicoba dengan cara :

Block range cell C5:C7  à Format Cells à Custom à Type isi dengan  #.000

 

Semoga sesuai harapan.

 

Salam,

DD

From: hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] 
[mailto:belajar-excel@yahoogroups.com] 
Sent: 22 April 2015 10:51
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

 

  

Hai Seismica,

 

Jawaban atas pertanyaan pertama... kayaknya ga bisa.

 

Jawaban atas pertanyaan kedua:

=A5&REPT(" ",10)&B5&REPT(" ",10)&C5

 

Salam,

HK

 

 

  _  

From: "Zerlinda Seismica seism...@yahoo.com [belajar-excel]" 

To: belajar-excel@yahoogroups.com 
Sent: Wednesday, 22 April 2015, 9:17
Subject: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad [1 
Attachment]

 

  

Assalamualaikum wrwb

 

Sebelumnya terima kasih buat Mas Kid dan Mas Hendrik atas solusi 
kemrin...semoga tidak bosen lagi untuk memberi pencerahan...

Problemnya adalah menampilkan angka nol didepan angka asli..solusi saya pake 
tanda kutip tapi jadi text padahal saya ingin number.

Yang kedua data dari excel dicopy paste ke notepad/textpad tp harus ada spasi 
tertentu..untuk detailnya saya kirimkan kadonya...

ITu aja...semoga tetep diberi semangat

 

 

Wassalam wrwb

Seismica

 

 

  _  

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.

Fw: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad

[hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel]]

Terima kasih mas Dede atas koreksinya.
Salam,HK

- Forwarded Message -
  From: "Dede pmaho_l...@nabatisnack.co.id [belajar-excel]" 

 To: belajar-excel@yahoogroups.com 
 Sent: Wednesday, 22 April 2015, 11:41
 Subject: RE: [belajar-excel] Menampilkan Angka Nol dan CopyPaste ke Notepad
   
    Ohiya formulanya akan mengalami sedikit perubahan menjadi : 
=A5&REPT("";10)&B5&REPT(" ";10)&TEXT(C5;"000") Ambildari formula Mr HK.    
Salam, DD    

From: dedepmaho_l...@nabatisnack.co.id 
[belajar-excel][mailto:belajar-excel@yahoogroups.com] 
Sent: 22 April 2015 11:38
To: belajar-excel@yahoogroups.com
Subject: RE: [belajar-excel] Menampilkan Angka Nol dan CopyPaste keNotepad      
 Ikutan yah...   Mungkin untuk pertanyaan pertama bisa dicobadengan cara : 
Block range cell C5:C7  à Format Cells àCustom à Type isi dengan  #.000   
Semoga sesuai harapan.   Salam, DD From:hendrik karnadi 
hendrikkarn...@yahoo.com [belajar-excel][mailto:belajar-excel@yahoogroups.com] 
Sent: 22 April 2015 10:51
To: belajar-excel@yahoogroups.com
Subject: Re: [belajar-excel] Menampilkan Angka Nol dan CopyPaste keNotepad     
Hai Seismica,   Jawaban ataspertanyaan pertama... kayaknya ga bisa.   Jawaban 
ataspertanyaan kedua: =A5&REPT("",10)&B5&REPT(" ",10)&C5   Salam, HK     From: 
"Zerlinda seismicaseism...@yahoo.com [belajar-excel]" 

To: belajar-excel@yahoogroups.com 
Sent: Wednesday, 22 April 2015, 9:17
Subject: [belajar-excel]Menampilkan Angka Nol dan CopyPaste ke Notepad [1 
Attachment]      Assalamualaikumwrwb   Sebelumnya terimakasih buat Mas Kid dan 
Mas Hendrik atas solusi kemrin...semoga tidak bosen lagiuntuk memberi 
pencerahan... Problemnya adalahmenampilkan angka nol didepan angka asli..solusi 
saya pake tanda kutip tapijadi text padahal saya ingin number. Yang kedua 
datadari excel dicopy paste ke notepad/textpad tp harus ada spasi 
tertentu..untukdetailnya saya kirimkan kadonya... ITu aja...semogatetep diberi 
semangat     Wassalam wrwb Seismica     This e-mail andany files 
transmitted with it are confidential and intended solely for the useof the 
individual to whom it is addressed. If you have received this email inerror 
please send it back to the person that sent it to you. Any views oropinions 
presented are solely those of its author and do not necessarilyrepresent those 
of NABATI or any of its subsidiary companies. Unauthorizedpublication, use, 
dissemination, forwarding, printing or copying of this emailand its associated 
attachments is strictly prohibited.#yiv7052079183 #yiv7052079183 -- 
#yiv7052079183ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 
0;padding:0 10px;}#yiv7052079183 #yiv7052079183ygrp-mkp hr {border:1px solid 
#d8d8d8;}#yiv7052079183 #yiv7052079183ygrp-mkp #yiv7052079183hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv7052079183 #yiv7052079183ygrp-mkp #yiv7052079183ads 
{margin-bottom:10px;}#yiv7052079183 #yiv7052079183ygrp-mkp .yiv7052079183ad 
{padding:0 0;}#yiv7052079183 #yiv7052079183ygrp-mkp .yiv7052079183ad p 
{margin:0;}#yiv7052079183 #yiv7052079183ygrp-mkp .yiv7052079183ad a 
{color:#ff;text-decoration:none;}#yiv7052079183 #yiv7052079183ygrp-sponsor 
#yiv7052079183ygrp-lc {font-family:Arial;}#yiv7052079183 
#yiv7052079183ygrp-sponsor #yiv7052079183ygrp-lc #yiv7052079183hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7052079183 
#yiv7052079183ygrp-sponsor #yiv7052079183ygrp-lc .yiv7052079183ad 
{margin-bottom:10px;padding:0 0;}#yiv7052079183 #yiv7052079183actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7052079183 
#yiv7052079183activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7052079183
 #yiv7052079183activity span {font-weight:700;}#yiv7052079183 
#yiv7052079183activity span:first-child 
{text-transform:uppercase;}#yiv7052079183 #yiv7052079183activity span a 
{color:#5085b6;text-decoration:none;}#yiv7052079183 #yiv7052079183activity span 
span {color:#ff7900;}#yiv7052079183 #yiv7052079183activity span 
.yiv7052079183underline {text-decoration:underline;}#yiv7052079183 
.yiv7052079183attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv7052079183 .yiv7052079183attach div a 
{text-decoration:none;}#yiv7052079183 .yiv7052079183attach img 
{border:none;padding-right:5px;}#yiv7052079183 .yiv7052079183attach label 
{display:block;margin-bottom:5px;}#yiv7052079183 .yiv7052079183attach label a 
{text-decoration:none;}#yiv7052079183 blockquote {margin:0 0 0 
4px;}#yiv7052079183 .yiv7052079183bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7052079183 
.yiv7052079183bold a {text-decoration:none;}#yiv7052079183 dd.yiv7052079183last 
p a {font-family:Verdana;font-weight:700;}#yiv7052079183 dd.yiv7052079183last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7052079183 
dd.yiv7052079183last p span.yiv7052079183yshortcuts 
{margin-right:0;}#yiv7052079183 di