Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index


Hi :)
Just forwarding Alex's excellent answer jic Dennis is not subscribed
to this mailing list.  Judging from the 10hours with no response that
seems quite likely.  Errr, actually we didn't get Alex's link on-list
but hopefully he can do "Reply to all" to make sure Dennis and all do
get it this time.
Regards from
Tom :)

On 21 February 2014 23:57, Alex McMurchy
<mcmurchy1917-libreoffice@yahoo.co.uk> wrote:

Try this link. Specifically the function getAmountInWord in the described macro.

Don't try the extension.

Alex




On Friday 21 Feb 2014 15:29:18 Tom Davies wrote:
Hi :)
It's an unusual problem that looks a lot like a fairly frequently
asked question.  Your question has an extra twist which we didn't
notice earlier.

I am not sure if there is an easy way to convert numbers to words.  ie
2,000 to "Two thousand"

So far people have been talking about how to make the numbers look
like numbers still but just be unable to perform calculations using
them.  It's good for telephone numbers, zip-codes and that sort of
thing.

There might be an "Extension" (what other people call "Add-ons" or
"Plug-ins") to do that in LibreOffice itself or there might be a
separate "app" (or program) that can do this outside of LibreOffice.
Our Extensions page is here;
http://www.libreoffice.org/features/extensions/
Most are written by 3rd parties but some are very popular.  There are
also Extensions written for OpenOffice which might still work with LO
or it might be easy to contact their devs to ask them if they could
update it for LO.

Sorry this isn't very helpful!
Apols and regards from
Tom :)




On 21 February 2014 13:28, C <grx1au@y7mail.com> wrote:
Hi there!

You can convert a number in text if you place an apostrophe sign before your
number (e.g. '123). Also, you can select desired cells and then use Format
menu>Cells....>Numbers tab>Category>Text >OK.

Cristi


On 21/02/2014 09:55, Dennis Regan wrote:

MY EMAIL ADDRESS IS: DennisPRegan2@hotmail.com

DEAR SIR OR MS.,

MY NAME IS DENNIS REGAN AND I HAVE A QUESTION FOR YOU THAT I COULDN'T FIND
THE ANSWER TO ONLINE OR IN LibreOffice Calc Help.

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

THERE ARE AN AWFUL LOT OF FORMULAS AND SYNTAX FOR EXCEL ONLINE FOR THIS
BUT NONE WORK IN LibreOffice Calc.

PLEASE ADVISE AS SOON AS POSSIBLE USING THIS EMAIL OR THE EMAIL ADDRESS
FOUND ABOVE. THANK YOU!

Very Sincerely,

Dennis Regan



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.