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