Forum Discussion
Require Number to word formula in excel without VBA Code
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.
=webservice("http://e.anyoupin.cn/eh3/?NumToBengali~" & A2)=webservice("http://e.anyoupin.cn/eh3/?NumToBengali~10.5")
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.- which is actually not solving my purpose.
where not solving?
replace dollars with Taka?
