To use the function (which converts numbers into Indonesian words like "seratus ribu") in WPS Office Spreadsheets , you can use a custom Visual Basic for Applications (VBA) add-in or a formula script.
If you are using the free version of WPS Office and cannot load external .xla add-ins, you can embed the code directly into your specific workbook using the macro editor. Open your workbook in WPS Spreadsheets. Press to open the VBA Editor. Click Insert > Module .
At the bottom of the window, ensure "Excel Add-ins" is selected in the dropdown and click Browse and Load button in the popup. Locate and select the Terbilang.xlam file you downloaded. Ensure "Terbilang" is checked in the list and click Verify Functionality In any cell, try typing the formula: =TERBILANG(A1) (where A1 contains a number). The cell should now display the number in Indonesian words. Alternative: Using a Formula (No Download Required) download add in terbilang wps office
: The standard free version generally disables VBA/Macro capabilities.
Which of WPS Office you are currently running (Free or Premium)? To use the function (which converts numbers into
"Terbilang" is an Indonesian word that translates to "spelled out" in English. In the context of office software, an add-in "Terbilang" refers to a function or tool that automatically converts numeric values into their written word form in a specific language (most commonly Indonesian, e.g., "150000" to "Seratus Lima Puluh Ribu Rupiah" ).
This happens if your installation of WPS Office lacks VBA support. Press to open the VBA Editor
Save the file to a permanent folder on your computer (e.g., C:\AddIns\ ). Do not delete or move this file later, or the formula will stop working. Step 2: Check WPS Office Version Requirements
Once installed, you can use the custom formula directly in your cells. While exact formula names may vary by the specific add-in version, the standard usage is:
(atau plugin ) adalah sebuah file eksternal yang dirancang untuk memperluas fungsionalitas dari suatu aplikasi. Untuk WPS Office, file ini biasanya berformat .XLA (untuk Excel 97–2003) atau .XLAM (untuk Excel 2007 ke atas), yang berisi kode Visual Basic for Applications (VBA) khusus.