If your downloaded add-in uses different names, adapt accordingly.
Before you hit the download button, you need to understand what separates a low-quality add-in from an extra quality one. A premium Terbilang add-in should offer:
| Feature | Extra Quality Standard | Low Quality Standard |
|---------|------------------------|----------------------|
| Currency Support | IDR, USD, MYR, SGD, EUR | Only IDR |
| Decimal Handling | Accurately spells "sen" or "cents" | Ignores decimals or rounds up |
| Compatibility | WPS Office 2019, 2020, 2021, 2023+ | Only old versions |
| Installation | One-click, no coding required | Requires macro security tweaks |
| Function Name | Simple: =TERBILANG(A1) | Complex: =SPELLNUMBER_INDONESIA |
| Stability | No crashes, handles millions/billions | Crashes with large numbers |
Extra Quality also means the add-in preserves your WPS spreadsheet formatting, supports both Indonesian and English spelling options, and works offline without internet dependency. download add in terbilang wps office extra quality
This is a stylistic choice. Extra quality add-ins offer a parameter to toggle formal vs. colloquial forms. Check your add-in's documentation for =TERBILANG(A1, "FORMAL").
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 your downloaded add-in uses different names, adapt
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"
If you’re a developer or power user, building a custom add-in ensures maximum quality. Here’s a skeleton code in VBA for WPS: Before you hit the download button, you need
Function TERBILANG_EXTRA(ByVal angka As Double, Optional currency As String = "IDR") As String
' Extra quality logic here
' Handles billions, millions, thousands, hundreds, tens, ones
' Includes decimal "sen" for IDR
' Returns fully formatted Indonesian spelling
End Function
You can expand this to include error handling, uppercase first letter, and punctuation insertion.
This is the most stable and modern method.
Visit: Github.com – search "terbilang wps office addin"
One example repository (check if still active): yussan/terbilang-wps – provides a .wadd file.
Alternatively, use WPS Add-in Developer Tool to create your own Terbilang add-in using JavaScript/HTML – this guarantees compatibility with all WPS versions and is the true "extra quality" method for developers.