Ask Your Question
0

How to use NUMBERTEXT or MONEYTEXT functions?

asked 2014-04-16 02:56:51 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
1

answered 2014-04-16 08:43:59 +0200

oweng gravatar image

updated 2014-04-16 08:49:32 +0200

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:

Usage

=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:

=numbertext("help")

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.

edit flag offensive delete link more
0

answered 2015-02-17 00:23:15 +0200

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

Regards

edit flag offensive delete link more
0

answered 2016-10-27 17:42:23 +0200

tomatt gravatar image

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 5.2.2.2

Help !

Regards

edit flag offensive delete link more

Comments

Sorry - I just found numbertext 0.9.5 which works fine !

tomatt gravatar imagetomatt ( 2016-10-27 17:47:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2014-04-16 02:56:51 +0200

Seen: 2,546 times

Last updated: Oct 27 '16