Forum Discussion
Require Number to word formula in excel without VBA Code
=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?- 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.
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.
