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
#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:#0000ff;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
#666666;height:62px;overflow:hidden;width:62px;}#yiv6545788072
#yiv6545788072photos div label
{color:#666666;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%;}#yiv6545788072 .yiv6545788072replbq
{margin:4px;}#yiv6545788072 #yiv6545788072ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6545788072 #yiv6545788072ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6545788072
#yiv6545788072ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6545788072
#yiv6545788072ygrp-mlmsg select, #yiv6545788072 input, #yiv6545788072 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6545788072
#yiv6545788072ygrp-mlmsg pre, #yiv6545788072 code {font:115%
monospace;}#yiv6545788072 #yiv6545788072ygrp-mlmsg *
{line-height:1.22em;}#yiv6545788072 #yiv6545788072ygrp-mlmsg #yiv6545788072logo
{padding-bottom:10px;}#yiv6545788072 #yiv6545788072ygrp-msg p a
{font-family:Verdana;}#yiv6545788072 #yiv6545788072ygrp-msg
p#yiv6545788072attach-count span {color:#1E66AE;font-weight:700;}#yiv6545788072
#yiv6545788072ygrp-reco #yiv6545788072reco-head
{color:#ff7900;font-weight:700;}#yiv6545788072 #yiv6545788072ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6545788072 #yiv6545788072ygrp-sponsor
#yiv6545788072ov li a {font-size:130%;text-decoration:none;}#yiv6545788072
#yiv6545788072ygrp-sponsor #yiv6545788072ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6545788072
#yiv6545788072ygrp-sponsor #yiv6545788072ov ul {margin:0;padding:0 0 0
8px;}#yiv6545788072 #yiv6545788072ygrp-text
{font-family:Georgia;}#yiv6545788072 #yiv6545788072ygrp-text p {margin:0 0 1em
0;}#yiv6545788072 #yiv6545788072ygrp-text tt {font-size:120%;}#yiv6545788072
#yiv6545788072ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6545788072
