HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

users
#21

Please download and install

http://extensions.libreoffice.org/extension-center/numbertext-1

I needed to format a number to written (long-hand) for a check. This did produce what was needed.

When using MONEYTEXT(), reference your cell with the number in it. Although the command asks for more, it is not required. It appears to format from the default languages settings.
Make sure your language settings are correct.

I did not test NUMBERTEXT, also within this extension.

Hope this helps.

Paul

#22

That extension worked for me both for NumberText and MoneyText.

In my previous post I'd was talking about version 0.9.4. I didn't realise there was a newer version!

Alex

#23

If I could change the extension (maybe I will try) I would make optional or
remove the name of the currency and have first letter of initial word
capitalized or possibly first letter of each word.

If I wish to write $35.50 I would write "Thirty-five dollars and fifty
cents", not "Thirty-five US dollars and fifty cents".

#24

I believe the traditional way to write this on a check is, "Thirty-five and 50/100 dollars"

#25

Good point. That's certainly the way I've done it. And the word "dollars"
is preprinted on the checks I've used so the program output for check
printing should only be "Thirty-five and 50/10".