The guide below explains how to find and install the Terbilang add-in for WPS Office to automate converting numbers into words. Direct Solution
To download the Terbilang add-in, users typically look for the Excel (.xla or .xlam) version. Because WPS Spreadsheets is highly compatible with Excel, the same macro file works across both platforms. Download a trusted terbilang.xla file. Open WPS Spreadsheets. Go to Developer > Add-ins. Browse and select the downloaded file. 🛠️ Step-by-Step Installation
While "Extra Quality" often refers to versions with currency support (like Rupiah), the setup process remains the same. 1. Enable Developer Tab Open WPS Spreadsheets. Click the Menu icon (top left). Select Options > Customize Ribbon. Check the box for Developer and click OK. 2. Import the Add-in Click the Developer tab. Select Add-Ins. Click Add/Browse. Locate your terbilang.xla or .xlam file. Ensure the "Terbilang" checkbox is ticked. 3. Usage Formula
Once installed, use the following syntax in any cell:=terbilang(A1) 💎 Features of "Extra Quality" Versions
Standard add-ins just convert digits to words. "Extra Quality" versions usually offer: Currency Support: Adds "Rupiah" or "Dollars" automatically.
Case Sensitivity: Functions like PROPER, UPPER, or LOWER built-in. Decimal Handling: Accurate conversion for cents or "sen." Language Options: Toggle between Indonesian and English. ⚠️ Important Troubleshooting download add in terbilang wps office extra quality
VBA Support: Ensure you have the WPS Office VBA version installed. The free "Standard" version may not support .xla macros without the VBA module.
Security Blocks: If the formula returns #NAME?, go to Trust Center and set Macro Settings to "Enable all macros."
File Path: Do not move the .xla file after installing, or the link will break. Why Use Terbilang? Speed: No manual typing for receipts. Accuracy: Eliminates human error in financial docs. Professionalism: Perfect for invoices and payroll.
Remove the old add-in from Developer > Add-Ins, restart WPS, then add the new version. Never overwrite while WPS is open.
If your downloaded add-in uses different names, adapt accordingly. The guide below explains how to find and
Change "Rupiah" to "Ringgit" or "Dollar":
CurrencyUnit = "Rupiah" 'Change to "Dollar" or "Yen"
Add Decimal Handling (Sen/Cents): Find the line that splits the integer and fraction:
If Fraction > 0 Then
Terbilang = Terbilang & " Koma " & TerbilangAngka(Fraction)
End If
Change to:
If Fraction > 0 Then
Terbilang = Terbilang & " Sen " & TerbilangAngka(Fraction)
End If
Fix "Satu Ribu" vs "Seribu": Extra quality versions automatically change "Satu Ribu" to "Seribu". Ensure your script has this logic:
If Number = 1000 Then
Hasil = "Seribu"
ElseIf Number = 100 Then
Hasil = "Seratus"
A. From WPS Template/Add-in center (recommended) 999 | 999
B. From a downloaded workbook or script (manual)
C. Converting a VBA macro or Excel add-in (.xlam/.xla) to WPS
| Feature | Standard Terbilang | Extra Quality Terbilang | |---------|-------------------|--------------------------| | Handles "sen" (decimals) | No | Yes | | Formal "Seribu" instead of "Satu Ribu" | No | Yes | | Supports negative numbers | No | Yes | | Works in WPS Free version | No (needs VBA) | No (still needs VBA) | | Max value | 999,999 | 999,999,999 |
You can use Terbilang inside letters and invoices:
=TERBILANG(mergefield) formula using WPS’s field codes.Since there is no official WPS add-in store listing for Terbilang, follow these steps to source a tested, quality version.