alhamdulilah yang kesekian kalinya.....semua masalah yang diajukan disini
langsung tuntas..disini komunitas ngumpul para mastah xl..suwun semuanya Pak HK
dan Pak Dede....
Salam Seismica
Pada Rabu, 22 April 2015 12:01, "Dede pmaho_l...@nabatisnack.co.id
[belajar-excel]" <belajar-excel@yahoogroups.com> menulis:
#yiv4582917493 #yiv4582917493 -- #yiv4582917493
.yiv4582917493ygrp-photo-title{clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}#yiv4582917493
div.yiv4582917493ygrp-photo{background-position:center;background-repeat:no-repeat;background-color:white;border:1px
solid black;height:62px;width:62px;}#yiv4582917493
div.yiv4582917493photo-title a, #yiv4582917493 div.yiv4582917493photo-title
a:active, #yiv4582917493 div.yiv4582917493photo-title a:hover, #yiv4582917493
div.yiv4582917493photo-title a:visited {text-decoration:none;}#yiv4582917493
div.yiv4582917493attach-table div.yiv4582917493attach-row
{clear:both;}#yiv4582917493 div.yiv4582917493attach-table
div.yiv4582917493attach-row div {float:left;}#yiv4582917493 p
{clear:both;padding:15px 0 3px 0;overflow:hidden;}#yiv4582917493
div.yiv4582917493ygrp-file {width:30px;}#yiv4582917493
div.yiv4582917493attach-table div.yiv4582917493attach-row div div a
{text-decoration:none;}#yiv4582917493 div.yiv4582917493attach-table
div.yiv4582917493attach-row div div span {font-weight:normal;}#yiv4582917493
div.yiv4582917493ygrp-file-title {font-weight:bold;}#yiv4582917493
#yiv4582917493 #yiv4582917493 #yiv4582917493 -- _filtered #yiv4582917493
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv4582917493
{font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #yiv4582917493
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv4582917493
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv4582917493
{font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv4582917493
{font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #yiv4582917493
{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv4582917493
#yiv4582917493 p.yiv4582917493MsoNormal, #yiv4582917493
li.yiv4582917493MsoNormal, #yiv4582917493 div.yiv4582917493MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4582917493 a:link,
#yiv4582917493 span.yiv4582917493MsoHyperlink
{color:blue;text-decoration:underline;}#yiv4582917493 a:visited, #yiv4582917493
span.yiv4582917493MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv4582917493 p
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4582917493 code
{}#yiv4582917493 pre
{margin:0cm;margin-bottom:.0001pt;font-size:10.0pt;}#yiv4582917493 tt
{}#yiv4582917493 span.yiv4582917493cat {}#yiv4582917493 span.yiv4582917493ct
{}#yiv4582917493 span.yiv4582917493HTMLPreformattedChar
{font-family:Consolas;}#yiv4582917493 p.yiv4582917493attach, #yiv4582917493
li.yiv4582917493attach, #yiv4582917493 div.yiv4582917493attach
{margin-right:0cm;margin-left:0cm;font-size:9.0pt;}#yiv4582917493
p.yiv4582917493bold, #yiv4582917493 li.yiv4582917493bold, #yiv4582917493
div.yiv4582917493bold
{margin-right:0cm;margin-left:0cm;font-size:10.0pt;font-weight:bold;}#yiv4582917493
p.yiv4582917493green, #yiv4582917493 li.yiv4582917493green, #yiv4582917493
div.yiv4582917493green
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;color:#628C2A;}#yiv4582917493
p.yiv4582917493replbq, #yiv4582917493 li.yiv4582917493replbq, #yiv4582917493
div.yiv4582917493replbq {margin:3.0pt;font-size:12.0pt;}#yiv4582917493
p.yiv4582917493ad, #yiv4582917493 li.yiv4582917493ad, #yiv4582917493
div.yiv4582917493ad
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4582917493
p.yiv4582917493underline, #yiv4582917493 li.yiv4582917493underline,
#yiv4582917493 div.yiv4582917493underline
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4582917493
span.yiv4582917493yshortcuts {}#yiv4582917493 p.yiv4582917493ad1,
#yiv4582917493 li.yiv4582917493ad1, #yiv4582917493 div.yiv4582917493ad1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;}#yiv4582917493
p.yiv4582917493ad2, #yiv4582917493 li.yiv4582917493ad2, #yiv4582917493
div.yiv4582917493ad2
{margin-right:0cm;margin-bottom:7.5pt;margin-left:0cm;font-size:12.0pt;}#yiv4582917493
p.yiv4582917493underline1, #yiv4582917493 li.yiv4582917493underline1,
#yiv4582917493 div.yiv4582917493underline1
{margin-right:0cm;margin-left:0cm;font-size:12.0pt;text-decoration:underline;}#yiv4582917493
span.yiv4582917493yshortcuts1 {font-weight:bold;}#yiv4582917493
span.yiv4582917493yshortcuts2 {font-weight:normal;}#yiv4582917493
span.yiv4582917493EmailStyle36 {color:windowtext;}#yiv4582917493
.yiv4582917493MsoChpDefault {font-size:10.0pt;} _filtered #yiv4582917493
{margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv4582917493 div.yiv4582917493Section1
{}#yiv4582917493 _filtered #yiv4582917493 {} _filtered #yiv4582917493
{font-family:Symbol;}#yiv4582917493 ol {margin-bottom:0cm;}#yiv4582917493 ul
{margin-bottom:0cm;}#yiv4582917493
Ikutanyah... Mungkinuntuk pertanyaan pertama bisa dicoba dengan cara :
Blockrange cell C5:C7 àFormat Cells à Custom à Type isi dengan #.000
Semogasesuai harapan. Salam, DD From: hendrik
karnadihendrikkarn...@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 atas pertanyaanpertama... kayaknya ga bisa.
Jawaban atas pertanyaan kedua: =A5&REPT("",10)&B5&REPT(" ",10)&C5 Salam, HK
From:"Zerlinda Seismica seism...@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] Assalamualaikum wrwb Sebelumnya terima kasih buatMas Kid
dan Mas Hendrik atas solusi kemrin...semoga tidak bosen lagi untukmemberi
pencerahan... Problemnya adalah menampilkanangka nol didepan angka asli..solusi
saya pake tanda kutip tapi jadi textpadahal saya ingin number. Yang kedua data
dari exceldicopy paste ke notepad/textpad tp harus ada spasi tertentu..untuk
detailnyasaya kirimkan kadonya... ITu aja...semoga tetep diberisemangat....
Wassalam wrwb Seismica This e-mail and any files transmitted with it
are confidential andintended solely for the use of the individual to whom it is
addressed. If youhave received this email in error please send it back to the
person that sentit to you. Any views or opinions presented are solely those of
its author anddo not necessarily represent those of NABATI or any of its
subsidiarycompanies. Unauthorized publication, use, dissemination, forwarding,
printingor copying of this email and its associated attachments is strictly
prohibited.
