SpellNumber Bangladeshi Taka Function is a ready-to-use Excel function created with VBA code to change given numbers to words in Bangladeshi Taka. In other words, it converts a numeric value of BDT to words along with poysha.
There is no inbuilt function in Excel to display the numeric value in words. The VBA code for the SpellNumber function for US dollars is available on the Microsoft website.
You can insert this function in your Excel workbook. It converts the numeric value to words as the name suggests.
For example, to display $ 2,345.50 as “Dollar Two Thousand Three Hundred Forty-Five and Fifty Cents”, you can use the SpellNumber Function.
Whereas, to display BDT 2,345.50 as ” Two Thousand Three Hundred Forty-Five Taka and Fifty Poysha”, you can use the SpellNumber Bangladeshi Taka Function.
We have edited the same code with some changes for the required result.
Let us discuss the whole step by step process to create this SpellNumber Function for Bangladeshi Taka using the VBA module.
How To Create SpellNumber Bangladeshi Taka Function
Following the below-given steps:
1. Open a new excel workbook.
2. Go To Developer Tab in the top ribbon.
3. Click on “Visual Basic” in the Code tab.
4. In the top menu, Go to insert Tab and Select “Module” shown below:
5. Copy the VBA code given below code and paste in the Module sheet.
VBA Code for SpellNumber Function for BDT
6. Click on the “Save” button. When you do this, a screen will display a dialog box as shown below.
Your file now consists of a macro thus you need to click the “No” option.
7. Select “Save As”.
Select the location and select the “Save as type” as an “Excel macro-enabled workbook”.
SpellNumber function for BDT (Bangladeshi Taka) is now ready to use.
How to Use SpellNumber Bangladeshi Taka Function
Let’s use that code that we inserted our excel workbook.
Insert number in column A. In column B insert the formula: = SpellNumberEDP2(A1, “BDT”). BDT is the string you need to enter in double inverted commas. Use the fill handle function to copy the formula in all rows.
The function displays the following result:
This function will only be available in this workbook.
Please keep in mind that every time you open this workbook or any other macro-enabled workbook you will get a security warning below the ribbon. See image below:
Select “Enable this content” and click on “OK”. Otherwise, the code will not function.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries or suggestions please share in the comment section below. I will be more than happy to assist you.