Open Office Extensions: NUMBERTEXT change Number to Text or Money

NUMBERTEXT and MONEYTEXT are spreadsheet functions for number to number name and currency name conversion proposed for OpenFormula standard. MONEYTEXT is functionally top-compliant with the ECMA/ISO standard BAHTTEXT function. Supported languages: Africaans, Belgian French, Brazilian Portuguese, Catalan, Chinese, Czech, Danish, Dutch, English, Esperanto, Finnish, French, German, Greek, Hungarian, Italian, Japanese, Korean, Luxembourgish, Polish, Portuguese, Romanian, Russian, Serbian (Latin and Cyrillic), Slovenian, Spanish, Swedish, Swiss French, Thai, Turkish.

Download

Installation and usage
Tools->Extension Manager->Add
After restarting OpenOffice.org, there are two new Calc functions, NUMBERTEXT() and MONEYTEXT(), i.e.:
=NUMBERTEXT(25)
=NUMBERTEXT(25;”th-TH”)
=MONEYTEXT(25)
=MONEYTEXT(25;”USD”)
=MONEYTEXT(25;”CNY”;”zh-ZH”)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s