Sama2.Kalau masih cukup waktu bisa dipelajari AddIns nya.Awalnya memang terasa
sulit untuk memebuat menginstal file AddIns nya, tapi keuntungannya bisa
digunakan seperti fungsi bawaan Excel (tanpa macro).
Salam,HK
From: "hartini dewi [email protected] [belajar-excel]"
<[email protected]>
To: "[email protected]" <[email protected]>
Sent: Monday, 4 May 2015, 12:40
Subject: Bls: Re: Bls: Re: [belajar-excel] merubah format cell Faktur Pajak
menjadi Number
| Dear pak hendrik,Berhasil terima kasih banyak ya.
Salam
tiny
Dikirim dari Yahoo Mail pada Android
| Dari:"Hendrik Karnadi [email protected] [belajar-excel]"
<[email protected]>
Tanggal:Sen, 4 Mei 2015 pada 13:05
Judul:Re: Bls: Re: [belajar-excel] merubah format cell Faktur Pajak menjadi
Number
Kalau msh bingung dengan AddIns, pakai UDF(User Defuned Function) saja.
Cara membuat dan menyimpannya sama seperti kita membuat dan menyimpan file
berisi Macro (Excel 2007 ke atas file extensionnya .xlsm atau .xlsb sedangkan
Excel 2003 file extensionnya .xls). UDF ini harus dibuat di Module.
Cara membuatnya: tekan Alt F11 untuk menampillan VBE Sheet, kemudian klik kanan
mouse pada object yang ada di sebelah kiri, lalu pilih Insert Modul...komputer
akan otomatis menampilkan Module1.Klik Module 1 lalu copas UDF yang ada dalam
jawaban email saya pada sisi sebelah kanan (kotak putih kosong). Simpan file
tsb seperti kita menyimpan file berisi Macro.
Untuk.mencobanya....Copas soalnya pada lembar kerja Excel, kmdn pada sel kosong
(mis. disebelahnya) ketik "=StringThok(celnya)" (tanpa apostrop).StringThok
adalah nama fungsi yang kita buat (boleh diganti).
Semoga penjelasan singkat ini cukup jelas.
Salam,HK
Sent from Samsung Mobile |
|
#yiv9964250005 #yiv9964250005 -- #yiv9964250005ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9964250005
#yiv9964250005ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9964250005
#yiv9964250005ygrp-mkp #yiv9964250005hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9964250005 #yiv9964250005ygrp-mkp #yiv9964250005ads
{margin-bottom:10px;}#yiv9964250005 #yiv9964250005ygrp-mkp .yiv9964250005ad
{padding:0 0;}#yiv9964250005 #yiv9964250005ygrp-mkp .yiv9964250005ad p
{margin:0;}#yiv9964250005 #yiv9964250005ygrp-mkp .yiv9964250005ad a
{color:#0000ff;text-decoration:none;}#yiv9964250005 #yiv9964250005ygrp-sponsor
#yiv9964250005ygrp-lc {font-family:Arial;}#yiv9964250005
#yiv9964250005ygrp-sponsor #yiv9964250005ygrp-lc #yiv9964250005hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9964250005
#yiv9964250005ygrp-sponsor #yiv9964250005ygrp-lc .yiv9964250005ad
{margin-bottom:10px;padding:0 0;}#yiv9964250005 #yiv9964250005actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9964250005
#yiv9964250005activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9964250005
#yiv9964250005activity span {font-weight:700;}#yiv9964250005
#yiv9964250005activity span:first-child
{text-transform:uppercase;}#yiv9964250005 #yiv9964250005activity span a
{color:#5085b6;text-decoration:none;}#yiv9964250005 #yiv9964250005activity span
span {color:#ff7900;}#yiv9964250005 #yiv9964250005activity span
.yiv9964250005underline {text-decoration:underline;}#yiv9964250005
.yiv9964250005attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9964250005 .yiv9964250005attach div a
{text-decoration:none;}#yiv9964250005 .yiv9964250005attach img
{border:none;padding-right:5px;}#yiv9964250005 .yiv9964250005attach label
{display:block;margin-bottom:5px;}#yiv9964250005 .yiv9964250005attach label a
{text-decoration:none;}#yiv9964250005 blockquote {margin:0 0 0
4px;}#yiv9964250005 .yiv9964250005bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9964250005
.yiv9964250005bold a {text-decoration:none;}#yiv9964250005 dd.yiv9964250005last
p a {font-family:Verdana;font-weight:700;}#yiv9964250005 dd.yiv9964250005last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9964250005
dd.yiv9964250005last p span.yiv9964250005yshortcuts
{margin-right:0;}#yiv9964250005 div.yiv9964250005attach-table div div a
{text-decoration:none;}#yiv9964250005 div.yiv9964250005attach-table
{width:400px;}#yiv9964250005 div.yiv9964250005file-title a, #yiv9964250005
div.yiv9964250005file-title a:active, #yiv9964250005
div.yiv9964250005file-title a:hover, #yiv9964250005 div.yiv9964250005file-title
a:visited {text-decoration:none;}#yiv9964250005 div.yiv9964250005photo-title a,
#yiv9964250005 div.yiv9964250005photo-title a:active, #yiv9964250005
div.yiv9964250005photo-title a:hover, #yiv9964250005
div.yiv9964250005photo-title a:visited {text-decoration:none;}#yiv9964250005
div#yiv9964250005ygrp-mlmsg #yiv9964250005ygrp-msg p a
span.yiv9964250005yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9964250005
.yiv9964250005green {color:#628c2a;}#yiv9964250005 .yiv9964250005MsoNormal
{margin:0 0 0 0;}#yiv9964250005 o {font-size:0;}#yiv9964250005
#yiv9964250005photos div {float:left;width:72px;}#yiv9964250005
#yiv9964250005photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9964250005
#yiv9964250005photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9964250005
#yiv9964250005reco-category {font-size:77%;}#yiv9964250005
#yiv9964250005reco-desc {font-size:77%;}#yiv9964250005 .yiv9964250005replbq
{margin:4px;}#yiv9964250005 #yiv9964250005ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9964250005 #yiv9964250005ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9964250005
#yiv9964250005ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9964250005
#yiv9964250005ygrp-mlmsg select, #yiv9964250005 input, #yiv9964250005 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9964250005
#yiv9964250005ygrp-mlmsg pre, #yiv9964250005 code {font:115%
monospace;}#yiv9964250005 #yiv9964250005ygrp-mlmsg *
{line-height:1.22em;}#yiv9964250005 #yiv9964250005ygrp-mlmsg #yiv9964250005logo
{padding-bottom:10px;}#yiv9964250005 #yiv9964250005ygrp-msg p a
{font-family:Verdana;}#yiv9964250005 #yiv9964250005ygrp-msg
p#yiv9964250005attach-count span {color:#1E66AE;font-weight:700;}#yiv9964250005
#yiv9964250005ygrp-reco #yiv9964250005reco-head
{color:#ff7900;font-weight:700;}#yiv9964250005 #yiv9964250005ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9964250005 #yiv9964250005ygrp-sponsor
#yiv9964250005ov li a {font-size:130%;text-decoration:none;}#yiv9964250005
#yiv9964250005ygrp-sponsor #yiv9964250005ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9964250005
#yiv9964250005ygrp-sponsor #yiv9964250005ov ul {margin:0;padding:0 0 0
8px;}#yiv9964250005 #yiv9964250005ygrp-text
{font-family:Georgia;}#yiv9964250005 #yiv9964250005ygrp-text p {margin:0 0 1em
0;}#yiv9964250005 #yiv9964250005ygrp-text tt {font-size:120%;}#yiv9964250005
#yiv9964250005ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9964250005
