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 <hendrikkarn...@yahoo.com>
To: "belajar-excel@yahoogroups.com" <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]"
<belajar-excel@yahoogroups.com>
To: "belajar-excel@yahoogroups.com" <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]"
<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 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:#0000ff;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 div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv3762872534
#yiv3762872534photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3762872534
#yiv3762872534reco-category {font-size:77%;}#yiv3762872534
#yiv3762872534reco-desc {font-size:77%;}#yiv3762872534 .yiv3762872534replbq
{margin:4px;}#yiv3762872534 #yiv3762872534ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3762872534 #yiv3762872534ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3762872534
#yiv3762872534ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3762872534
#yiv3762872534ygrp-mlmsg select, #yiv3762872534 input, #yiv3762872534 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3762872534
#yiv3762872534ygrp-mlmsg pre, #yiv3762872534 code {font:115%
monospace;}#yiv3762872534 #yiv3762872534ygrp-mlmsg *
{line-height:1.22em;}#yiv3762872534 #yiv3762872534ygrp-mlmsg #yiv3762872534logo
{padding-bottom:10px;}#yiv3762872534 #yiv3762872534ygrp-msg p a
{font-family:Verdana;}#yiv3762872534 #yiv3762872534ygrp-msg
p#yiv3762872534attach-count span {color:#1E66AE;font-weight:700;}#yiv3762872534
#yiv3762872534ygrp-reco #yiv3762872534reco-head
{color:#ff7900;font-weight:700;}#yiv3762872534 #yiv3762872534ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3762872534 #yiv3762872534ygrp-sponsor
#yiv3762872534ov li a {font-size:130%;text-decoration:none;}#yiv3762872534
#yiv3762872534ygrp-sponsor #yiv3762872534ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3762872534
#yiv3762872534ygrp-sponsor #yiv3762872534ov ul {margin:0;padding:0 0 0
8px;}#yiv3762872534 #yiv3762872534ygrp-text
{font-family:Georgia;}#yiv3762872534 #yiv3762872534ygrp-text p {margin:0 0 1em
0;}#yiv3762872534 #yiv3762872534ygrp-text tt {font-size:120%;}#yiv3762872534
#yiv3762872534ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3762872534
