NUMBERTEXT translates numbers into words.
=NUMBERTEXT(1)
You might want to get the number in a neighboring cell in words, for example, A1
. Then add the formula
=NUMBERTEXT(A1)
For some reason, do you need to get a number in another language? In Russian?
=NUMBERTEXT(123, "ru")
Would you like to translate the currency into words?
=MONEYTEXT(123, "USD")
Help is built into the function. In any cell write
=NUMBERTEXT("help")
Hmm ... By the way,
How much is that at all !?
This program is distributed free of charge.
NUMBERTEXT is completely based on the libnumbertext library (BSD 3-Clause License) for JavaScript and implements the Soros interpreter without changes.
An useful add-on for Google Sheets
The Google QUERY alternative for Google Sheets