In this article, we want to share how to convert number to Bangladeshi taka in excel easily and earlier than writing phrases manually. like as, you write the number â€˜123â€™. However, now you do not want to type to MS Excel manually. Whatever you wish to convert number to Bangladeshi taka (Taka One Hundred Twenty Three), you need to use this function: =BangladeshiTaka (Required cell). You want to follow these steps first:

1. Create a new excel file first
2. Press Alt + F11, to open Microsoft Visual Basic (or go to View -> Module)
3. TheÂ Microsoft Visual Basic to the Insert menu levels to ModuleÂ Click on.
4. Copy the written down code to avoid wasting time.
5. Save the code and close Microsoft Visual Editor.

How to use:Â Suppose, you write the desired number (123) as cell A1 and you want to convert this number in cell A2. Then you should use the formula in cell A2 as like =BangladeshiTaka(A1).

We think, now you can easily convert numbers to Bangladeshi taka using this formula. If you face any difficulty, then you are welcome to contact us.

###### EasilyÂ Convert number to Bangladeshi Taka in excel, windows 11 feature Microsoft Excel

The article was published on August 11, 2018 @ 1:05 PM

### 9 Comments

• Md.Mamunur Rashid says:

Thanks a lot brother.I have spent many times but lastly I got solution from your authentic post.

• Mahir Shahriyar says:

There is a bug I have faced while using this formula. If the amount ends in thousands only, the “Taka” string is omitted from the start of the result.

Example Amount: 18000
Result= Eighteen Thousand Only

Expected Result = Taka Eighteen Thousand Only

Fantastic formula regardless. Thank you for the contribution.

• Thanks a lot for your observation, Mahir Vai.
I understand the problem and have already solved it. Will you please check again and let me know your reply??

• tofazzal says:

formula not working in my excell sheet

• Please share your screenshot and error message here…

• Mohammad Rafiqul Islam says:

Thanks a lot brother.I have spent many times but lastly I got solution from your authentic post.In YouTube most of them are fraud.

• Aminul Islam says:

Thanks

• Ishtiak says:

Thank You Selim.
Your Blog are really helpful