Ask Your Question

How to use MONEYTEXT functions?

asked 2019-01-23 08:07:40 +0200

aycayassi1 gravatar image

updated 2019-01-23 21:16:45 +0200

erAck gravatar image

I tried a lot of combinations but I can not convert it to English language. Although I wrote en-US like in function example, it doesnt work. I'm using Turkish LibreOffice, so text is Turkish.

=MONEYTEXT(D1;"USD") it works, but =MONEYTEXT(D1;"usd") doesnt work. When I try it from function windows, it also doesnt work.

I tried to change my LibreOffice language and tried the extension, it also doesnt work for language.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2019-01-24 05:58:08 +0200

aycayassi1 gravatar image

Yes, thank you. Maybe I tried "EN" with uppercase. I also tried en-US in the example they didnt work.

edit flag offensive delete link more

answered 2019-01-23 21:16:26 +0200

erAck gravatar image

Haven't the Numbertext extension currently installed myself, but the second argument likely is case significant, so for US-Dollar it must be upper case "USD", as you already found out. If you want the text in a different language you can try with a third argument, without such argument probably either the system UI or locale language is used. So, =MONEYTEXT(D1;"USD";"en") for English.

The extension's pkg-desc/pkg-description.txt also mentions =NUMBERTEXT("help") to display some extra help. See also answer to this question.

edit flag offensive delete link more


... and the new [NatNum12] cell formatting option ;-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-01-23 21:38:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-23 08:07:40 +0200

Seen: 288 times

Last updated: Jan 24 '19