O
O
Old_disciple2021-02-01 15:54:47
Google Sheets
Old_disciple, 2021-02-01 15:54:47

How to implement automatic conversion of numbers to letters?

Dear experts, good day to all!
Can you please tell me whether it is possible to implement such a thing as translating numbers into letters?
the meaning of the idea is as follows:
In cell "D2" there is a figure of $ 1000.35
According to the idea, in cell "A4", a message like this is automatically generated:
"Taking into account everything: 1000 (one thousand) US dollars 35 cents"
And if the figure is not in $ and in rubles, then a message like this:
"Taking into account everything: 1000 (one thousand) rubles 35 kopecks"
The same scheme with the euro.
Approximately my idea looks like this: https://docs.google.com/spreadsheets/d/1r2wpTNeX3z...
Thank you.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
A
Alexander Ivanov, 2021-02-01
@Old_disciple

Try the addon https://contributor.pw/post/add-on-numbertext/

B
BasiC2k, 2021-02-01
@BasiC2k

This is called "amount in words". Google the algorithm and translate it into java script

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question