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
   |

      #yiv8557896855 #yiv8557896855 -- #yiv8557896855ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8557896855 
#yiv8557896855ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8557896855 
#yiv8557896855ygrp-mkp #yiv8557896855hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv8557896855 #yiv8557896855ygrp-mkp #yiv8557896855ads 
{margin-bottom:10px;}#yiv8557896855 #yiv8557896855ygrp-mkp .yiv8557896855ad 
{padding:0 0;}#yiv8557896855 #yiv8557896855ygrp-mkp .yiv8557896855ad p 
{margin:0;}#yiv8557896855 #yiv8557896855ygrp-mkp .yiv8557896855ad a 
{color:#0000ff;text-decoration:none;}#yiv8557896855 #yiv8557896855ygrp-sponsor 
#yiv8557896855ygrp-lc {font-family:Arial;}#yiv8557896855 
#yiv8557896855ygrp-sponsor #yiv8557896855ygrp-lc #yiv8557896855hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8557896855 
#yiv8557896855ygrp-sponsor #yiv8557896855ygrp-lc .yiv8557896855ad 
{margin-bottom:10px;padding:0 0;}#yiv8557896855 #yiv8557896855actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8557896855 
#yiv8557896855activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8557896855
 #yiv8557896855activity span {font-weight:700;}#yiv8557896855 
#yiv8557896855activity span:first-child 
{text-transform:uppercase;}#yiv8557896855 #yiv8557896855activity span a 
{color:#5085b6;text-decoration:none;}#yiv8557896855 #yiv8557896855activity span 
span {color:#ff7900;}#yiv8557896855 #yiv8557896855activity span 
.yiv8557896855underline {text-decoration:underline;}#yiv8557896855 
.yiv8557896855attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv8557896855 .yiv8557896855attach div a 
{text-decoration:none;}#yiv8557896855 .yiv8557896855attach img 
{border:none;padding-right:5px;}#yiv8557896855 .yiv8557896855attach label 
{display:block;margin-bottom:5px;}#yiv8557896855 .yiv8557896855attach label a 
{text-decoration:none;}#yiv8557896855 blockquote {margin:0 0 0 
4px;}#yiv8557896855 .yiv8557896855bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8557896855 
.yiv8557896855bold a {text-decoration:none;}#yiv8557896855 dd.yiv8557896855last 
p a {font-family:Verdana;font-weight:700;}#yiv8557896855 dd.yiv8557896855last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8557896855 
dd.yiv8557896855last p span.yiv8557896855yshortcuts 
{margin-right:0;}#yiv8557896855 div.yiv8557896855attach-table div div a 
{text-decoration:none;}#yiv8557896855 div.yiv8557896855attach-table 
{width:400px;}#yiv8557896855 div.yiv8557896855file-title a, #yiv8557896855 
div.yiv8557896855file-title a:active, #yiv8557896855 
div.yiv8557896855file-title a:hover, #yiv8557896855 div.yiv8557896855file-title 
a:visited {text-decoration:none;}#yiv8557896855 div.yiv8557896855photo-title a, 
#yiv8557896855 div.yiv8557896855photo-title a:active, #yiv8557896855 
div.yiv8557896855photo-title a:hover, #yiv8557896855 
div.yiv8557896855photo-title a:visited {text-decoration:none;}#yiv8557896855 
div#yiv8557896855ygrp-mlmsg #yiv8557896855ygrp-msg p a 
span.yiv8557896855yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8557896855 
.yiv8557896855green {color:#628c2a;}#yiv8557896855 .yiv8557896855MsoNormal 
{margin:0 0 0 0;}#yiv8557896855 o {font-size:0;}#yiv8557896855 
#yiv8557896855photos div {float:left;width:72px;}#yiv8557896855 
#yiv8557896855photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv8557896855 
#yiv8557896855photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8557896855
 #yiv8557896855reco-category {font-size:77%;}#yiv8557896855 
#yiv8557896855reco-desc {font-size:77%;}#yiv8557896855 .yiv8557896855replbq 
{margin:4px;}#yiv8557896855 #yiv8557896855ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv8557896855 #yiv8557896855ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8557896855 
#yiv8557896855ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8557896855 
#yiv8557896855ygrp-mlmsg select, #yiv8557896855 input, #yiv8557896855 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8557896855 
#yiv8557896855ygrp-mlmsg pre, #yiv8557896855 code {font:115% 
monospace;}#yiv8557896855 #yiv8557896855ygrp-mlmsg * 
{line-height:1.22em;}#yiv8557896855 #yiv8557896855ygrp-mlmsg #yiv8557896855logo 
{padding-bottom:10px;}#yiv8557896855 #yiv8557896855ygrp-msg p a 
{font-family:Verdana;}#yiv8557896855 #yiv8557896855ygrp-msg 
p#yiv8557896855attach-count span {color:#1E66AE;font-weight:700;}#yiv8557896855 
#yiv8557896855ygrp-reco #yiv8557896855reco-head 
{color:#ff7900;font-weight:700;}#yiv8557896855 #yiv8557896855ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv8557896855 #yiv8557896855ygrp-sponsor 
#yiv8557896855ov li a {font-size:130%;text-decoration:none;}#yiv8557896855 
#yiv8557896855ygrp-sponsor #yiv8557896855ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8557896855 
#yiv8557896855ygrp-sponsor #yiv8557896855ov ul {margin:0;padding:0 0 0 
8px;}#yiv8557896855 #yiv8557896855ygrp-text 
{font-family:Georgia;}#yiv8557896855 #yiv8557896855ygrp-text p {margin:0 0 1em 
0;}#yiv8557896855 #yiv8557896855ygrp-text tt {font-size:120%;}#yiv8557896855 
#yiv8557896855ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv8557896855 

  

Kirim email ke