How to format a number to its written form

AndrewToole · Post by **AndrewToole** » Thu Jan 08, 2015 4:39 pm

Hi,
I am trying to format a number to its written form.
For example: A1= $123.45
I want to be able to make A2= "$ One hundred twenty three and 45/100"
Any help would be greatly appreciated. Thanks.

Mr.Dandy · Post by **Mr.Dandy** » Thu Jan 08, 2015 5:52 pm

Hello,
Searching in the forum: viewtopic.php?f=9&t=45719&hilit=numbers+to+words

Post by **Zizi64** » Thu Jan 08, 2015 5:59 pm

This extension can make something similatr thing:

http://extensions.libreoffice.org/exten ... mbertext-1
http://extensions.services.openoffice.o ... numbertext

Code: Select all

=MONEYTEXT(A2;"USD";"en")

Post by **Zizi64** » Thu Jan 08, 2015 6:20 pm

or use the NUMBERTEXT() function from the extension:

Code: Select all

="$ "&NUMBERTEXT(INT(A2);"en") & " and " & TEXT(100*(A2-INT(A2));"00") &"/100"

Post by **karolus** » Thu Jan 08, 2015 11:24 pm

Hallo

Maybe

Code: Select all

="$ "&NUMBERTEXT(INT(A2);"en")&TEXT(MOD(A2;1);"??/100")

Karolus

How to format a number to its written form

How to format a number to its written form

Re: how to format a number to its written form

Re: how to format a number to its written form

Re: how to format a number to its written form

Re: how to format a number to its written form