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
#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:#0000ff;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
#666666;height:62px;overflow:hidden;width:62px;}#yiv3795287868
#yiv3795287868photos div label
{color:#666666;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%;}#yiv3795287868
#yiv3795287868ygrp-mlmsg select, #yiv3795287868 input, #yiv3795287868 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3795287868
#yiv3795287868ygrp-mlmsg pre, #yiv3795287868 code {font:115%
monospace;}#yiv3795287868 #yiv3795287868ygrp-mlmsg *
{line-height:1.22em;}#yiv3795287868 #yiv3795287868ygrp-mlmsg #yiv3795287868logo
{padding-bottom:10px;}#yiv3795287868 #yiv3795287868ygrp-msg p a
{font-family:Verdana;}#yiv3795287868 #yiv3795287868ygrp-msg
p#yiv3795287868attach-count span {color:#1E66AE;font-weight:700;}#yiv3795287868
#yiv3795287868ygrp-reco #yiv3795287868reco-head
{color:#ff7900;font-weight:700;}#yiv3795287868 #yiv3795287868ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3795287868 #yiv3795287868ygrp-sponsor
#yiv3795287868ov li a {font-size:130%;text-decoration:none;}#yiv3795287868
#yiv3795287868ygrp-sponsor #yiv3795287868ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3795287868
#yiv3795287868ygrp-sponsor #yiv3795287868ov ul {margin:0;padding:0 0 0
8px;}#yiv3795287868 #yiv3795287868ygrp-text
{font-family:Georgia;}#yiv3795287868 #yiv3795287868ygrp-text p {margin:0 0 1em
0;}#yiv3795287868 #yiv3795287868ygrp-text tt {font-size:120%;}#yiv3795287868
#yiv3795287868ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3795287868
