How to use NUMBERTEXT or MONEYTEXT functions?

I can’t seem to get these to work. Does anyone have a simple instruction to use these functions? NUMBERTEXT only has two variables, yet I can’t seem to get a result from that function.

=NUMBERTEXT(F7,English) should result in the text version of cell F7 but all I get is $NAME?

I’ve also tried =NUMBERTEXT(F7,EN) same result.

Is this function operating?

The package description (i.e., pkg-desc/pkg-description.txt in the OXT) from the current v0.9.5 release of the NumberText extension offers these helpful examples:


=numbertext(5) → “five”

=numbertext(5;"de") → “fünf”

=moneytext(5;"USD") → “five dollars”

=moneytext(5;"HUF";"hu") → “öt forint”

Help for extra functions and modules of the default language:


Examples for using extra functions:

=moneytext(1; "ord"; "en") (English ordinal numbers) → “first”

=moneytext(999; "ord2"; "en") (English ordinal abbreviations) → “1st”

I can confirm that under Debian 7 x86_64 using v4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72 and Crunchbang 11 x86_64 using v4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f this extension is still working as expected.

moneytext(45.5) in MXN how can generate cuareta y cinco pesos 50/100 MN ??? what is the rigth parameter for this.

I just get cuarenta y cinco pesos mexicanos con cincuenta centavos but I can’t use this in pay check for example


I always get Err.504, even with entering simply =numbertext(5)

I’ve tried the function wizard too - the parameter boxes don’t appear.

Using Numbertext 0.9.4 and LibreOffice

Help !


Sorry - I just found numbertext 0.9.5 which works fine !