When it comes to data manipulation, spreadsheets like Microsoft Excel are a go-to tool for many professionals. However, not everyone knows how to fully utilize Excel’s functions, such as the Terbilang feature. In this article, we’ll explore how to use Terbilang in Excel, including downloading and installing the feature, and provide examples of its usefulness.
What is Terbilang?
Terbilang is a feature in Microsoft Excel that allows users to convert numerical figures into written words. For example, if you enter the number “500” into a Terbilang formula, the result will be “five hundred.” This feature is particularly handy for financial and accounting documents, as well as invoices and checks.
Downloading Terbilang Excel
The first step to using Terbilang in Excel is to download and install the feature. Here’s how to do it:
- Go to the Microsoft Excel Add-ins website.
- Search for the “Terbilang” add-in.
- Download the add-in for your Excel version (e.g., Excel 2010, Excel 2013, Excel 2016).
- Open the downloaded file and follow the installation instructions.
Once the Terbilang add-in is installed, it will appear as an external function within your Excel formulas.
Using Terbilang in Excel
Now that you’ve installed Terbilang, let’s explore how to use it within your Excel spreadsheets.
Step 1: Insert the Terbilang Formula
To use Terbilang, you’ll need to insert its formula within a cell in your Excel spreadsheet. The formula is:
=terbilang(value)
In this formula, “value” refers to the numerical value you want to convert into words. For example, to convert the value “500” into words, you would enter the formula:
=terbilang(500)
And the result will be:
lima ratus
Step 2: Customize the Result
You can customize the result of your Terbilang formula by specifying additional parameters. Here are a few examples:
- Include Currency: If you want to include the currency symbol (e.g., “USD”), you can add a second parameter to the formula. Here’s an example:
- Uppercase or Lowercase: You can specify whether you want the result to be in uppercase or lowercase letters by adding a third parameter to the formula. Here are examples of both:
- Exclude Currency: If you don’t want to include the currency symbol in the result, you can leave the second parameter blank. Here’s an example:
=terbilang(500,”USD”)
five hundred US dollars
=terbilang(500,””,”upper”)
LIMA RATUS
=terbilang(500,””,”lower”)
lima ratus
=terbilang(500,””)
lima ratus
Terbilang Examples
Terbilang can be useful in a variety of scenarios, particularly in financial and accounting documents. Here are a few examples:
Example 1: Invoices
When creating an invoice, it’s important to include both the numerical amount owed and the written amount. This can help prevent any confusion or mistakes. Here’s an example of how to use Terbilang in an invoice:
Invoice #12345
To: Jane Doe
Amount Due: $1,500 (one thousand five hundred dollars)
Example 2: Checks
Writing a check requires both the numerical amount and the written amount. Terbilang can help ensure accuracy and clarity on the check. Here’s an example:
Pay to the Order of: John Smith
Amount: $500 (five hundred dollars)
FAQ
Q: Is Terbilang available in all Excel versions?
A: No, Terbilang is only available in certain Excel versions. You’ll need to check the Microsoft Excel Add-ins website to see if it’s available for your version.
Q: Can Terbilang be used with non-numerical values?
A: No, Terbilang can only be used with numerical values.
Conclusion
Terbilang is a useful feature in Microsoft Excel, particularly for financial and accounting purposes. By following the steps to download and install the function, as well as customizing its parameters, you can easily convert numerical figures into written words. With its practical applications, Terbilang is definitely worth exploring for Excel users.