Require Number to word formula in excel without VBA Code

Occasional Contributor

Hi All,

I need a formula for numbers to words without a VBA code. My currency is Taka instead of Dollars and after the decimal, it's called Paisa instead of Cent. Also require the word Only, in the last.
Here is the sample for a better understanding
1 = One Taka Only
10 = Ten Taka Only
10.50 = Ten Taka Fifty Paisa Only
100 = One Hundred Taka Only
1000 = One Thousand Taka Only
10000 = Ten Thousand Taka Only
100000 = One Lac Taka Only (We called Lac for one hundred thousand)
1000000 = Ten Lac Taka Only
10000000 = One Crore Taka Only

Please help me with this formula if anyone can able to do so.

Thanks in advance.

6 Replies

@istiakahmed 

 

You would do well to check out this thread from three-and-a-half years ago. 

https://techcommunity.microsoft.com/t5/excel/excel-numtowords-formula/m-p/727433

 

You'll need to read the whole thread to see how to use the formula, and you'll want to revise it. In the meantime, I'm going to see about turning it into a LAMBDA function, since that's technology that has come along more recently.

 

Speaking of Lamda, what version of Excel are you using? For Lamda, you'll need to have a Microsoft 365 subscription. For LET (another capability recently released) you'll need Excel 2021 or newer.

Hi @mathetes
Thanks for your response.
I'm currently using Microsoft 365 & 2021 both in my 2 PC.
I've checked your link already before, which is actually not solving my purpose. I've already tried with that formula and found it has some difficulties which I require.
That's why I had to open a new query with details of my requirement.

@istiakahmed 

 

You'll have to be patient then. I have set it as something to work on, but I do have other things to do as well.

 

I also sent a message to the originator of that earlier formula asking if he possibly has updated his approach.

which is actually not solving my purpose.

where not solving?

replace dollars with Taka?

Hi @peiyezhu,

I was trying with this formula mention above link
https://techcommunity.microsoft.com/t5/excel/excel-numtowords-formula/m-p/727433/page/2

I cannot add taka (dollars) and Paisa (cents) and the word "only in the last of my word.