Salin ( copy ) seluruh kode VBA terbilang yang ada pada bagian atas artikel ini.
Go to Developer > Macro Security . Set the security level to "Medium" or "Low" (only recommended if you trust the source of your Terbilang file) so that the macro can execute when the file opens. Conclusion
Cari file dengan nama seperti Fungsi_Terbilang.xlam atau Terbilang_WPS.bas . Sumber terpercaya antara lain: download add in terbilang wps office
To add the function (which converts numbers into Indonesian words) to WPS Office Spreadsheets, you must manually install it as an add-in, as it is not built-in by default. 1. Download the Terbilang Add-In
Fungsi terbilang tidak tersedia secara bawaan di WPS Spreadsheet. Anda harus mengunduh file add-in terlebih dahulu. Ada beberapa cara untuk mendapatkan file ini: Salin ( copy ) seluruh kode VBA terbilang
Function Terbilang(ByVal Angka As Double) As String Dim Satuan As Variant Dim Hasil As String Dim i As Integer Satuan = Array("", "Satu", "Dua", "Tiga", "Empat", "Lima", "Enam", "Tujuh", "Delapan", "Sembilan", "Sepuluh", "Sebelas") 'Logika konversi (disederhanakan untuk artikel) If Angka < 12 Then Terbilang = Satuan(Angka) ElseIf Angka < 20 Then Terbilang = Satuan(Angka Mod 10) & " Belas" ElseIf Angka < 100 Then Terbilang = Satuan(Angka \ 10) & " Puluh " & Satuan(Angka Mod 10) Else Terbilang = "Angka terlalu besar, perlu kode lengkap" End If
Once installed, you can use the function directly in any cell. For example: =terbilang(A1) converts the number in cell A1 to words. =PROPER(terbilang(A1)) & " Rupiah" Conclusion Cari file dengan nama seperti Fungsi_Terbilang
Ensure the "Terbilang" option is checked in the list and click 4. How to Use the Formula
Pada bagian File Type , ubah menjadi . Cara Menggunakan Rumus Terbilang di Lembar Kerja