Forum Discussion
Numbers2Wordsλ in Excel 365
Nice idea. I didn't dig the function itself, couple of comments on results
- layout is different, we have both "few dollars AND some cents", or "few dollars some cents" (without and)
- actually we have to use double translation, e.g.
=TRANSLATE( Numbers2Wordsλ(amount,"en","RUB"),,"ru")
I realize the flaws of the approach in relying on BAHTTEXT and the translation that may/may not include AND before the fractional unit. It made me think - "What is the correct way to say it out loud?" If one is to factor for all the anomalies, then the approach (which becomes messy!) might as well be different was my thinking. I had to take into account baht(s), satang, and "net" which often follows an amount.
Mainly, the reason for sharing a flawed Lambda is to put it into existence so it may stimulate discussion. I've not seen anyone else attempt this yet so far. Here it is and here's the good and the bad!
This function, perhaps with small adjustments, could be quite useful, especially if we shift from currency to currency. If only not to follow strict guidance's on corporate or like levels. Even for one language it could be
one dollar only
one and 00/100 dollars
one dollar and zero cents
etc., etc.,...