Ask Your Question
0

How to use NUMBERTEXT or MONEYTEXT functions? [closed]

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-14 15:04:31.395819

3 Answers

Sort by » oldest newest most voted
1

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

oweng gravatar image

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

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 +0100

romer3r gravatar image

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 +0100

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 +0100 )edit

Question Tools

1 follower

Stats

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

Seen: 4,069 times

Last updated: Oct 27 '16