Dear Pak Toby, Ternyata dengan format English US pun sama hasilnya, masih terjadi kendala pembulatan jika format pada sheet "Formula Terbilang" menjadi =Text(B3,"000000000000000") atau tanpa desimal. Mohon petunjuk. Terima kasih. Salam,HK
----- Forwarded Message -----
From: "hendrik karnadi [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, 5 May 2015, 10:26
Subject: Fw: [belajar-excel] Fungsi terbilang [1 Attachment]
Dear Pak Toby,Setelah saya coba lagi dengan format Indoensian ternyata
masih ada kendala pembulatan
Angka 88888,88
=Terbilang nya menjadi
| Delapan Puluh Delapan Ribu Delapan Ratus Delapan Puluh Sembilan Delapan Puluh
Delapan Per Seratus |
File terlampir
Dimana salahnya ya ?
Terima kasih.
Salam,HK
----- Forwarded Message -----
From: "hendrik karnadi [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Tuesday, 5 May 2015, 7:48
Subject: Fw: [belajar-excel] Fungsi terbilang
Dear Pak Toby,Sudah saya tes di Excel 2010 dan 2013, berhasil.Excel 2003
dan 2007 pun seharusnya bisa.Terima kasih.
Salam,HK
----- Forwarded Message -----
From: "Hendrik Karnadi [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Monday, 4 May 2015, 22:28
Subject: Re: [belajar-excel] Fungsi terbilang
Terima kasih pak Toby.Saya pake excel 2010 dan 2013, bsk akan saya coba dan
info hasilnya.
Salam,HK
Sent from Samsung Mobile
-------- Original message --------From: "Toby kenzo [email protected]
[belajar-excel]" Date:04/05/2015 20:28 (GMT+07:00)
To: [email protected] Subject: Re: [belajar-excel] Fungsi terbilang
| Dear pak Hendrik,Coba di ganti pada sheet "Formula Terbilang" pada cell B11,
yg smula formulanya : =Text(B3,"000000000000000.00") menjadi
=Text(B3,"000000000000000")
saya sudah ganti dari setting region Indonesia ke English(United States) dan
sebaliknya.nolnya ada 15...
It's work in Office 2013 SP1
TerimaKasih.Sent from Yahoo Mail on Android |
From: hendrik karnadi [email protected] [belajar-excel]
<[email protected]>;
To: [email protected] <[email protected]>;
Subject: [belajar-excel] Fungsi terbilang [1 Attachment]
Sent: Mon, May 4, 2015 9:43:22 AM
| Dear Be-Excelers,Terlampir adalah sedikit modifikasi dari file mba Siti
VI mengenai pemanfaatan "Formula Terbilang",dimana angkanya bisa ditaruh dimana
saja pada sheet "Terbilang" dan diberi Nama Range "Angka".
Nama Range ini dijadikan reference oleh sheet "Formula Terbilang" sebagai
pegolah data untuk menghasilkan terbilang dalam huruf.
Hasil olah data berupa terbilang dalam huruf yang dihasilkan oleh sheet
"Formula Terbilang" kemudian dijadikan referensi kembali oleh sheet "Terbilang"
untuk menampilkan terbilang dalam huruf.
Semuanya berjalan dengan baik dengan Regional Setting English-US.
Ketika saya mencoba mengganti Regional Setting menjadi
Indonesian...menghasilkan #Value! baik pada sheet "Formula Terbilang" maupun
sheet "Terbilang"
Pertanyaan saya:Bagaimana membuat terbilang dalam huruf yang fleksibel (bisa
dipergunakan dengan Regional Setting English-US maupun Indonesian?
Terima kasih.
Salam,HK
|
#yiv8735911847 #yiv8735911847 -- #yiv8735911847ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8735911847
#yiv8735911847ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8735911847
#yiv8735911847ygrp-mkp #yiv8735911847hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8735911847 #yiv8735911847ygrp-mkp #yiv8735911847ads
{margin-bottom:10px;}#yiv8735911847 #yiv8735911847ygrp-mkp .yiv8735911847ad
{padding:0 0;}#yiv8735911847 #yiv8735911847ygrp-mkp .yiv8735911847ad p
{margin:0;}#yiv8735911847 #yiv8735911847ygrp-mkp .yiv8735911847ad a
{color:#0000ff;text-decoration:none;}#yiv8735911847 #yiv8735911847ygrp-sponsor
#yiv8735911847ygrp-lc {font-family:Arial;}#yiv8735911847
#yiv8735911847ygrp-sponsor #yiv8735911847ygrp-lc #yiv8735911847hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8735911847
#yiv8735911847ygrp-sponsor #yiv8735911847ygrp-lc .yiv8735911847ad
{margin-bottom:10px;padding:0 0;}#yiv8735911847 #yiv8735911847actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8735911847
#yiv8735911847activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8735911847
#yiv8735911847activity span {font-weight:700;}#yiv8735911847
#yiv8735911847activity span:first-child
{text-transform:uppercase;}#yiv8735911847 #yiv8735911847activity span a
{color:#5085b6;text-decoration:none;}#yiv8735911847 #yiv8735911847activity span
span {color:#ff7900;}#yiv8735911847 #yiv8735911847activity span
.yiv8735911847underline {text-decoration:underline;}#yiv8735911847
.yiv8735911847attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8735911847 .yiv8735911847attach div a
{text-decoration:none;}#yiv8735911847 .yiv8735911847attach img
{border:none;padding-right:5px;}#yiv8735911847 .yiv8735911847attach label
{display:block;margin-bottom:5px;}#yiv8735911847 .yiv8735911847attach label a
{text-decoration:none;}#yiv8735911847 blockquote {margin:0 0 0
4px;}#yiv8735911847 .yiv8735911847bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8735911847
.yiv8735911847bold a {text-decoration:none;}#yiv8735911847 dd.yiv8735911847last
p a {font-family:Verdana;font-weight:700;}#yiv8735911847 dd.yiv8735911847last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8735911847
dd.yiv8735911847last p span.yiv8735911847yshortcuts
{margin-right:0;}#yiv8735911847 div.yiv8735911847attach-table div div a
{text-decoration:none;}#yiv8735911847 div.yiv8735911847attach-table
{width:400px;}#yiv8735911847 div.yiv8735911847file-title a, #yiv8735911847
div.yiv8735911847file-title a:active, #yiv8735911847
div.yiv8735911847file-title a:hover, #yiv8735911847 div.yiv8735911847file-title
a:visited {text-decoration:none;}#yiv8735911847 div.yiv8735911847photo-title a,
#yiv8735911847 div.yiv8735911847photo-title a:active, #yiv8735911847
div.yiv8735911847photo-title a:hover, #yiv8735911847
div.yiv8735911847photo-title a:visited {text-decoration:none;}#yiv8735911847
div#yiv8735911847ygrp-mlmsg #yiv8735911847ygrp-msg p a
span.yiv8735911847yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8735911847
.yiv8735911847green {color:#628c2a;}#yiv8735911847 .yiv8735911847MsoNormal
{margin:0 0 0 0;}#yiv8735911847 o {font-size:0;}#yiv8735911847
#yiv8735911847photos div {float:left;width:72px;}#yiv8735911847
#yiv8735911847photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8735911847
#yiv8735911847photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8735911847
#yiv8735911847reco-category {font-size:77%;}#yiv8735911847
#yiv8735911847reco-desc {font-size:77%;}#yiv8735911847 .yiv8735911847replbq
{margin:4px;}#yiv8735911847 #yiv8735911847ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8735911847 #yiv8735911847ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8735911847
#yiv8735911847ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8735911847
#yiv8735911847ygrp-mlmsg select, #yiv8735911847 input, #yiv8735911847 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8735911847
#yiv8735911847ygrp-mlmsg pre, #yiv8735911847 code {font:115%
monospace;}#yiv8735911847 #yiv8735911847ygrp-mlmsg *
{line-height:1.22em;}#yiv8735911847 #yiv8735911847ygrp-mlmsg #yiv8735911847logo
{padding-bottom:10px;}#yiv8735911847 #yiv8735911847ygrp-msg p a
{font-family:Verdana;}#yiv8735911847 #yiv8735911847ygrp-msg
p#yiv8735911847attach-count span {color:#1E66AE;font-weight:700;}#yiv8735911847
#yiv8735911847ygrp-reco #yiv8735911847reco-head
{color:#ff7900;font-weight:700;}#yiv8735911847 #yiv8735911847ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8735911847 #yiv8735911847ygrp-sponsor
#yiv8735911847ov li a {font-size:130%;text-decoration:none;}#yiv8735911847
#yiv8735911847ygrp-sponsor #yiv8735911847ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8735911847
#yiv8735911847ygrp-sponsor #yiv8735911847ov ul {margin:0;padding:0 0 0
8px;}#yiv8735911847 #yiv8735911847ygrp-text
{font-family:Georgia;}#yiv8735911847 #yiv8735911847ygrp-text p {margin:0 0 1em
0;}#yiv8735911847 #yiv8735911847ygrp-text tt {font-size:120%;}#yiv8735911847
#yiv8735911847ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8735911847
ctv_Terbilang (Kendala pembulatan).xlsx
Description: MS-Excel 2007 spreadsheet

