sory rumus yang betul adalah
=SUBSTITUTE(TRIM(IF(MOD(LEN(C5*D5),3)=0," ",LEFT(C5*D5,MOD(LEN(C5*D5),3)))&"
"&MID(C5*D5,MOD(LEN(C5*D5),3)+1,3)&" "&MID(C5*D5,MOD(LEN(C5*D5),3)+4,3)&"
"&MID(C5*D5,MOD(LEN(C5*D5),3)+7,3)&"
"&MID(C5*D5,MOD(LEN(C5*D5),3)+10,3)&MID(C5*D5,MOD(LEN(C5*D5),3)+113,3))," ",".")
silahkan dicoba
wassalam
Ghozi Alkatiri
Pada Minggu, 29 September 2019 08.23.03 WIB, Cari Kebenaran
cahayailm...@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:
Terima kasih atas tanggapan para Master dan anggota milis.
Rumus dari Bapak Ghozi sudah saya coba terapkan. Kalau separator/pemisah-nya
sudah betul. Tetapi mohon maaf, mengapa hasil perkalian rumusnya kurang tepat.
Sebagai contoh: 10*1.000 = 2.000 seharusnya hasilnya adalah 10..000 bukan?.
File terlampir.
Terima kasih.
On Sun, Sep 29, 2019 at 6:09 AM Cari Kebenaran <cahayailm...@gmail.com> wrote:
Terima kasih atas tanggapannya. Iya, supaya pemisah ribuannya jadi titik
seperti yang dipakai Indonesia
On Fri, Sep 27, 2019 at 5:21 PM 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
wa'alaikumussalam wr wb
Boleh tahu kenapa diubah jadi bertipe text ? Apakah karena supaya pemisah
ribuannya jadi titik seperti yang dipakai Indonesia ?
On Fri, Sep 27, 2019 at 4:59 PM Cari Kebenaran cahayailm...@gmail.com
[belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Assalamu'alaikum Wr. Wb.
Para master dan anggota milis yang saya hormati. Tolong dibantu untuk keperluan
saya.
Saya ingin mengubah nilai angka pada suatu range yang dihasilkan dari rumus
menjadi berformat text tanpa menghilangkan tanda titik (.) sebagai separator
ribuannya. Selengkapnya silakan lihat lampiran.
Atas perhatian dan bantuannya saya ucapkan terima kasih
#yiv3273847992 #yiv3273847992 -- #yiv3273847992ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3273847992
#yiv3273847992ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3273847992
#yiv3273847992ygrp-mkp #yiv3273847992hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv3273847992 #yiv3273847992ygrp-mkp #yiv3273847992ads
{margin-bottom:10px;}#yiv3273847992 #yiv3273847992ygrp-mkp .yiv3273847992ad
{padding:0 0;}#yiv3273847992 #yiv3273847992ygrp-mkp .yiv3273847992ad p
{margin:0;}#yiv3273847992 #yiv3273847992ygrp-mkp .yiv3273847992ad a
{color:#0000ff;text-decoration:none;}#yiv3273847992 #yiv3273847992ygrp-sponsor
#yiv3273847992ygrp-lc {font-family:Arial;}#yiv3273847992
#yiv3273847992ygrp-sponsor #yiv3273847992ygrp-lc #yiv3273847992hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3273847992
#yiv3273847992ygrp-sponsor #yiv3273847992ygrp-lc .yiv3273847992ad
{margin-bottom:10px;padding:0 0;}#yiv3273847992 #yiv3273847992actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3273847992
#yiv3273847992activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3273847992
#yiv3273847992activity span {font-weight:700;}#yiv3273847992
#yiv3273847992activity span:first-child
{text-transform:uppercase;}#yiv3273847992 #yiv3273847992activity span a
{color:#5085b6;text-decoration:none;}#yiv3273847992 #yiv3273847992activity span
span {color:#ff7900;}#yiv3273847992 #yiv3273847992activity span
.yiv3273847992underline {text-decoration:underline;}#yiv3273847992
.yiv3273847992attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv3273847992 .yiv3273847992attach div a
{text-decoration:none;}#yiv3273847992 .yiv3273847992attach img
{border:none;padding-right:5px;}#yiv3273847992 .yiv3273847992attach label
{display:block;margin-bottom:5px;}#yiv3273847992 .yiv3273847992attach label a
{text-decoration:none;}#yiv3273847992 blockquote {margin:0 0 0
4px;}#yiv3273847992 .yiv3273847992bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv3273847992
.yiv3273847992bold a {text-decoration:none;}#yiv3273847992 dd.yiv3273847992last
p a {font-family:Verdana;font-weight:700;}#yiv3273847992 dd.yiv3273847992last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3273847992
dd.yiv3273847992last p span.yiv3273847992yshortcuts
{margin-right:0;}#yiv3273847992 div.yiv3273847992attach-table div div a
{text-decoration:none;}#yiv3273847992 div.yiv3273847992attach-table
{width:400px;}#yiv3273847992 div.yiv3273847992file-title a, #yiv3273847992
div.yiv3273847992file-title a:active, #yiv3273847992
div.yiv3273847992file-title a:hover, #yiv3273847992 div.yiv3273847992file-title
a:visited {text-decoration:none;}#yiv3273847992 div.yiv3273847992photo-title a,
#yiv3273847992 div.yiv3273847992photo-title a:active, #yiv3273847992
div.yiv3273847992photo-title a:hover, #yiv3273847992
div.yiv3273847992photo-title a:visited {text-decoration:none;}#yiv3273847992
div#yiv3273847992ygrp-mlmsg #yiv3273847992ygrp-msg p a
span.yiv3273847992yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3273847992
.yiv3273847992green {color:#628c2a;}#yiv3273847992 .yiv3273847992MsoNormal
{margin:0 0 0 0;}#yiv3273847992 o {font-size:0;}#yiv3273847992
#yiv3273847992photos div {float:left;width:72px;}#yiv3273847992
#yiv3273847992photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv3273847992
#yiv3273847992photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3273847992
#yiv3273847992reco-category {font-size:77%;}#yiv3273847992
#yiv3273847992reco-desc {font-size:77%;}#yiv3273847992 .yiv3273847992replbq
{margin:4px;}#yiv3273847992 #yiv3273847992ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv3273847992 #yiv3273847992ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3273847992
#yiv3273847992ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3273847992
#yiv3273847992ygrp-mlmsg select, #yiv3273847992 input, #yiv3273847992 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv3273847992
#yiv3273847992ygrp-mlmsg pre, #yiv3273847992 code {font:115%
monospace;}#yiv3273847992 #yiv3273847992ygrp-mlmsg *
{line-height:1.22em;}#yiv3273847992 #yiv3273847992ygrp-mlmsg #yiv3273847992logo
{padding-bottom:10px;}#yiv3273847992 #yiv3273847992ygrp-msg p a
{font-family:Verdana;}#yiv3273847992 #yiv3273847992ygrp-msg
p#yiv3273847992attach-count span {color:#1E66AE;font-weight:700;}#yiv3273847992
#yiv3273847992ygrp-reco #yiv3273847992reco-head
{color:#ff7900;font-weight:700;}#yiv3273847992 #yiv3273847992ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv3273847992 #yiv3273847992ygrp-sponsor
#yiv3273847992ov li a {font-size:130%;text-decoration:none;}#yiv3273847992
#yiv3273847992ygrp-sponsor #yiv3273847992ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv3273847992
#yiv3273847992ygrp-sponsor #yiv3273847992ov ul {margin:0;padding:0 0 0
8px;}#yiv3273847992 #yiv3273847992ygrp-text
{font-family:Georgia;}#yiv3273847992 #yiv3273847992ygrp-text p {margin:0 0 1em
0;}#yiv3273847992 #yiv3273847992ygrp-text tt {font-size:120%;}#yiv3273847992
#yiv3273847992ygrp-vital ul li:last-child {border-right:none
!important;}#yiv3273847992
