Pendidikan tiada batas

Fungsi Terbilang pada Excel

Penambahan Add-Ins Mention _ Number. XLA ini memudahkan untuk mengubah bilangan menjadi huruf menggunakan fungsi TERBILANG dengan deklarasi =TERBILANG (selAcuan,0). Dahulu sebelum menemukan Add-Ins ini saya membuatnya secara manual. Waktu itu saya berhasil membuat  sampai tujuh dijit(dari nol sampai 9999999.

Sekarang adanya fungsi ini sangat membantu, misalnya untuk membuat raport dengan Excel, kuitansi, laporan keuangan koperasi, dan lain-lain. Pokonya banyak dah kegunaannya. Cara menginstallnya pun tidak terlalu sulit, seperti tutorial dari excel mania berikut ini.

Cara meninstall : download MENTION_NUMBER.XLA kemudian di ekstrak
1. Save “mention_number.xla” di harddisk [misalkan di D:\Dataku]
2. Buka Microsoft Excel
3. Buka Sheet baru
4. Klik [Menu] Tools
5. Klik [SubMenu] Add-Ins
6. Klik [Tombol] Browse
7. Cari File “mention_number.xla” di tempat Anda menyimpannya
8. OK

Bagi pengguna Microsoft Excel 2003, sebelum langkah pertama : Download di sini dulu MENTION_NUMBER.XLA kemudian diekstrak di folder yang ditentukan
0.1. Buka Microsoft Excel
0.2. Klik [Menu] Tools
0.3. Klik [SubMenu] Macro
0.4. Klik [SubMenu] Security
0.5. Pilih Low / Medium
0.5. OK

Cara menggunakan :
Jika angka yang akan ditulis dalam bentuk text ada di A1
di B1 ketik =TERBILANG(A1,1) jika ingin ada kata “Rupiah” dan “Sen” di belakang
di B1 ketik =TERBILANG(A1,0) jika tidak ingin ada kata “Rupiah” dan “Sen” di belakang
di B1 ketik =TERBILANG(INT(A1),1) jika ingin ada kata “Rupiah” tanpa kata “Sen” di belakang

File ini boleh disebar ke siapa saja. Jangan lupa kunjungi
http://groups.yahoo.com/group/XL-mania atau ExcelMania.com

Ikuti mailing list Microsoft Excel terbesar di Yahoogroups dengan mengirim e-mail kosong ke:
XL-mania-subscribe@yahoogroups.com

Pelajaran tentang fungsi ini dapat dilihat di :

http://groups.yahoo.com/group/XL-mania/files/Lessons/macro%20-%20mention_number.zip

Bugs report : XL-mania-owner@yahoogroups.com
Nantikan fungsi terbilang versi berikutnya

1. analisis butir soal menggunakan excel

2. membuat tabel produk momen sendiri menggunakan excel

3.  koreksi ulangan harian dengan excel

4. Mencari Hari Lahir dan WETON dengan excel

5. ulangan mengirim sms dikelola dengan excel

6. kartu perpustakaan dengan excel

29 Comments

  1. September 29, 2014    

    Supporters of the library hope that it will show other libraries how to adapt in response to an ever changing, digitalised society.
    The tube stations in close proximity to Hyde Park
    are Marble Arch, Queensway, Lancaster Gate, Knightsbridge Corner.
    London boasts of world class tourist attractions like Big Ben, Tower of London, London Eye, Hyde Park, Buckingham Palace,
    Westminster Abbey, Trafalgar Square, Madame Tussaud’s,
    St. Serviced apartments usually are well-equipped to handle the requirements of families
    of all kinds and preferences.
    serviced apartments london area code telah menulis..serviced apartments london area code

  2. September 10, 2014    

    I’m pretty pleased to uncover this great site. I wanted to
    thank you for your time just for this wonderful read!!
    I definitely savored every bit of it and i also have you book marked to look at
    new information in your website.
    how to learn how to tattoo telah menulis..how to learn how to tattoo

  3. EGHA's Gravatar EGHA
    January 15, 2013    

    BAGUS…………………………………………………….

    • budies's Gravatar budies
      January 15, 2013    

      sama-sama

  4. July 6, 2012    

    Terima kasih banyak yah..

  5. ummi kholish's Gravatar ummi kholish
    May 14, 2012    

    trims ilmunya pak guru…. izin copas

  6. Om Nugroho's Gravatar Om Nugroho
    November 21, 2011    

    kalau format nilai 8,50 pakai terbilang keluarnya delapan koma lima puluh, lah kalau pengin ndak pakai “puluh” tuh gimana, maksudnya biar keluarnya delapan koma lima nol ? trims

  7. November 6, 2010    

    thanks balik pak guru …

  8. budies's Gravatar budies
    November 6, 2010    

    @motorbreath: makasih shre-nya, saya akan kesana

  1. RAPORT DENGAN EXCEL | www.budies.info on August 7, 2010 at 05:50

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Download this post as PDF
CommentLuv badge

Bootstrap Examples

    Hello, world!

    This is a simple hero unit, a simple jumbotron-style component for calling extra attention to featured content or information.

    Learn more



    Oh snap! You got an error!

    Change this and that and try again. Duis mollis, est non commodo luctus, nisi erat porttitor ligula, eget lacinia odio sem nec elit. Cras mattis consectetur purus sit amet fermentum.

    Take this action Or do this


    Warning! Best check yo self, you're not looking too good.

    Well done! You successfully read this important alert message.

    Heads up! This alert needs your attention, but it's not super important.
    Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven't heard of them accusamus labore sustainable VHS.
    Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven't heard of them accusamus labore sustainable VHS.
    Anim pariatur cliche reprehenderit, enim eiusmod high life accusamus terry richardson ad squid. 3 wolf moon officia aute, non cupidatat skateboard dolor brunch. Food truck quinoa nesciunt laborum eiusmod. Brunch 3 wolf moon tempor, sunt aliqua put a bird on it squid single-origin coffee nulla assumenda shoreditch et. Nihil anim keffiyeh helvetica, craft beer labore wes anderson cred nesciunt sapiente ea proident. Ad vegan excepteur butcher vice lomo. Leggings occaecat craft beer farm-to-table, raw denim aesthetic synth nesciunt you probably haven't heard of them accusamus labore sustainable VHS.
SEO Powered by Platinum SEO from Techblissonline
Plugin from the creators ofBrindes :: More at PlulzWordpress Plugins