Terima kasih mas Dede atas koreksinya.
Salam,HK
----- Forwarded Message -----
From: "Dede pmaho_l...@nabatisnack.co.id [belajar-excel]"
<belajar-excel@yahoogroups.com>
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]"
<belajar-excel@yahoogroups.com>
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:#0000ff;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 div.yiv7052079183attach-table div div a
{text-decoration:none;}#yiv7052079183 div.yiv7052079183attach-table
{width:400px;}#yiv7052079183 div.yiv7052079183file-title a, #yiv7052079183
div.yiv7052079183file-title a:active, #yiv7052079183
div.yiv7052079183file-title a:hover, #yiv7052079183 div.yiv7052079183file-title
a:visited {text-decoration:none;}#yiv7052079183 div.yiv7052079183photo-title a,
#yiv7052079183 div.yiv7052079183photo-title a:active, #yiv7052079183
div.yiv7052079183photo-title a:hover, #yiv7052079183
div.yiv7052079183photo-title a:visited {text-decoration:none;}#yiv7052079183
div#yiv7052079183ygrp-mlmsg #yiv7052079183ygrp-msg p a
span.yiv7052079183yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7052079183
.yiv7052079183green {color:#628c2a;}#yiv7052079183 .yiv7052079183MsoNormal
{margin:0 0 0 0;}#yiv7052079183 o {font-size:0;}#yiv7052079183
#yiv7052079183photos div {float:left;width:72px;}#yiv7052079183
#yiv7052079183photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7052079183
#yiv7052079183photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7052079183
#yiv7052079183reco-category {font-size:77%;}#yiv7052079183
#yiv7052079183reco-desc {font-size:77%;}#yiv7052079183 .yiv7052079183replbq
{margin:4px;}#yiv7052079183 #yiv7052079183ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7052079183 #yiv7052079183ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7052079183
#yiv7052079183ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7052079183
#yiv7052079183ygrp-mlmsg select, #yiv7052079183 input, #yiv7052079183 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7052079183
#yiv7052079183ygrp-mlmsg pre, #yiv7052079183 code {font:115%
monospace;}#yiv7052079183 #yiv7052079183ygrp-mlmsg *
{line-height:1.22em;}#yiv7052079183 #yiv7052079183ygrp-mlmsg #yiv7052079183logo
{padding-bottom:10px;}#yiv7052079183 #yiv7052079183ygrp-msg p a
{font-family:Verdana;}#yiv7052079183 #yiv7052079183ygrp-msg
p#yiv7052079183attach-count span {color:#1E66AE;font-weight:700;}#yiv7052079183
#yiv7052079183ygrp-reco #yiv7052079183reco-head
{color:#ff7900;font-weight:700;}#yiv7052079183 #yiv7052079183ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7052079183 #yiv7052079183ygrp-sponsor
#yiv7052079183ov li a {font-size:130%;text-decoration:none;}#yiv7052079183
#yiv7052079183ygrp-sponsor #yiv7052079183ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7052079183
#yiv7052079183ygrp-sponsor #yiv7052079183ov ul {margin:0;padding:0 0 0
8px;}#yiv7052079183 #yiv7052079183ygrp-text
{font-family:Georgia;}#yiv7052079183 #yiv7052079183ygrp-text p {margin:0 0 1em
0;}#yiv7052079183 #yiv7052079183ygrp-text tt {font-size:120%;}#yiv7052079183
#yiv7052079183ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7052079183
