Pak go tjwan ham
Coba ara yang mudah saja.
Misal angka ada di A1 dan hasil terbilang di B1
Tulis di C1=B1 & " rupiah"
#dikirim_pakai_mail.yahoo.com_tanpa_pulsa#
--------------------------------------------
On Mon, 18/12/17, go tjwan ham go_tjwan_...@yahoo.com [belajar-excel]
<belajar-excel@yahoogroups.com> wrote:
Subject: Re: [belajar-excel] Re: Rumus terbilang
To: belajar-excel@yahoogroups.com
Date: Monday, 18 December, 2017, 3:57 PM
Dear Pak Zainul,
Untuk
rumusnya sudah saya coba dan sudah tetapi bagaimana kalau
mau ditambahkan kata rupiah?
Sent
from Yahoo Mail on Android
On Mon, 18 Dec 2017 at
14:32, go tjwan ham<go_tjwan_...@yahoo.com>
wrote:
Thanks Pak Zainul
Sent
from Yahoo Mail on Android
On Mon, 18 Dec 2017 at 11:32, zainul_u...@yahoo.com
[belajar-excel]<belajar-excel@yahoogroups.com>
wrote:
Silakan dicoba rumus
terlampir.thanks,-zainul
---In belajar-excel@yahoogroups.com,
<go_tjwan_ham@...> wrote :
Dear Para Guru
Excel,
Mohon
bantuannya untuk membuat rumus terbilang.
Misalnya
di cell A1 terisi angka 1.235.800Bagaimana
rumus untuk terbilang dengan huruf?
Terimakasih
atas bantuannya.
Regard,
Go
Tjwan Ham
Sent
from Yahoo Mail on Android
#yiv4015195585 #yiv4015195585 --
#yiv4015195585ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}
#yiv4015195585 #yiv4015195585ygrp-mkp hr {
border:1px solid #d8d8d8;}
#yiv4015195585 #yiv4015195585ygrp-mkp #yiv4015195585hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}
#yiv4015195585 #yiv4015195585ygrp-mkp #yiv4015195585ads {
margin-bottom:10px;}
#yiv4015195585 #yiv4015195585ygrp-mkp .yiv4015195585ad {
padding:0 0;}
#yiv4015195585 #yiv4015195585ygrp-mkp .yiv4015195585ad p {
margin:0;}
#yiv4015195585 #yiv4015195585ygrp-mkp .yiv4015195585ad a {
color:#0000ff;text-decoration:none;}
#yiv4015195585 #yiv4015195585ygrp-sponsor
#yiv4015195585ygrp-lc {
font-family:Arial;}
#yiv4015195585 #yiv4015195585ygrp-sponsor
#yiv4015195585ygrp-lc #yiv4015195585hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}
#yiv4015195585 #yiv4015195585ygrp-sponsor
#yiv4015195585ygrp-lc .yiv4015195585ad {
margin-bottom:10px;padding:0 0;}
#yiv4015195585 #yiv4015195585actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#yiv4015195585 #yiv4015195585activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#yiv4015195585 #yiv4015195585activity span {
font-weight:700;}
#yiv4015195585 #yiv4015195585activity span:first-child {
text-transform:uppercase;}
#yiv4015195585 #yiv4015195585activity span a {
color:#5085b6;text-decoration:none;}
#yiv4015195585 #yiv4015195585activity span span {
color:#ff7900;}
#yiv4015195585 #yiv4015195585activity span
.yiv4015195585underline {
text-decoration:underline;}
#yiv4015195585 .yiv4015195585attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}
#yiv4015195585 .yiv4015195585attach div a {
text-decoration:none;}
#yiv4015195585 .yiv4015195585attach img {
border:none;padding-right:5px;}
#yiv4015195585 .yiv4015195585attach label {
display:block;margin-bottom:5px;}
#yiv4015195585 .yiv4015195585attach label a {
text-decoration:none;}
#yiv4015195585 blockquote {
margin:0 0 0 4px;}
#yiv4015195585 .yiv4015195585bold {
font-family:Arial;font-size:13px;font-weight:700;}
#yiv4015195585 .yiv4015195585bold a {
text-decoration:none;}
#yiv4015195585 dd.yiv4015195585last p a {
font-family:Verdana;font-weight:700;}
#yiv4015195585 dd.yiv4015195585last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#yiv4015195585 dd.yiv4015195585last p
span.yiv4015195585yshortcuts {
margin-right:0;}
#yiv4015195585 div.yiv4015195585attach-table div div a {
text-decoration:none;}
#yiv4015195585 div.yiv4015195585attach-table {
width:400px;}
#yiv4015195585 div.yiv4015195585file-title a, #yiv4015195585
div.yiv4015195585file-title a:active, #yiv4015195585
div.yiv4015195585file-title a:hover, #yiv4015195585
div.yiv4015195585file-title a:visited {
text-decoration:none;}
#yiv4015195585 div.yiv4015195585photo-title a,
#yiv4015195585 div.yiv4015195585photo-title a:active,
#yiv4015195585 div.yiv4015195585photo-title a:hover,
#yiv4015195585 div.yiv4015195585photo-title a:visited {
text-decoration:none;}
#yiv4015195585 div#yiv4015195585ygrp-mlmsg
#yiv4015195585ygrp-msg p a span.yiv4015195585yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#yiv4015195585 .yiv4015195585green {
color:#628c2a;}
#yiv4015195585 .yiv4015195585MsoNormal {
margin:0 0 0 0;}
#yiv4015195585 o {
font-size:0;}
#yiv4015195585 #yiv4015195585photos div {
float:left;width:72px;}
#yiv4015195585 #yiv4015195585photos div div {
border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}
#yiv4015195585 #yiv4015195585photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#yiv4015195585 #yiv4015195585reco-category {
font-size:77%;}
#yiv4015195585 #yiv4015195585reco-desc {
font-size:77%;}
#yiv4015195585 .yiv4015195585replbq {
margin:4px;}
#yiv4015195585 #yiv4015195585ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#yiv4015195585 #yiv4015195585ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}
#yiv4015195585 #yiv4015195585ygrp-mlmsg table {
font-size:inherit;font:100%;}
#yiv4015195585 #yiv4015195585ygrp-mlmsg select,
#yiv4015195585 input, #yiv4015195585 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#yiv4015195585 #yiv4015195585ygrp-mlmsg pre, #yiv4015195585
code {
font:115% monospace;}
#yiv4015195585 #yiv4015195585ygrp-mlmsg * {
line-height:1.22em;}
#yiv4015195585 #yiv4015195585ygrp-mlmsg #yiv4015195585logo {
padding-bottom:10px;}
#yiv4015195585 #yiv4015195585ygrp-msg p a {
font-family:Verdana;}
#yiv4015195585 #yiv4015195585ygrp-msg
p#yiv4015195585attach-count span {
color:#1E66AE;font-weight:700;}
#yiv4015195585 #yiv4015195585ygrp-reco
#yiv4015195585reco-head {
color:#ff7900;font-weight:700;}
#yiv4015195585 #yiv4015195585ygrp-reco {
margin-bottom:20px;padding:0px;}
#yiv4015195585 #yiv4015195585ygrp-sponsor #yiv4015195585ov
li a {
font-size:130%;text-decoration:none;}
#yiv4015195585 #yiv4015195585ygrp-sponsor #yiv4015195585ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}
#yiv4015195585 #yiv4015195585ygrp-sponsor #yiv4015195585ov
ul {
margin:0;padding:0 0 0 8px;}
#yiv4015195585 #yiv4015195585ygrp-text {
font-family:Georgia;}
#yiv4015195585 #yiv4015195585ygrp-text p {
margin:0 0 1em 0;}
#yiv4015195585 #yiv4015195585ygrp-text tt {
font-size:120%;}
#yiv4015195585 #yiv4015195585ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv4015195585
