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 <grx...@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: dennispreg...@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+unsubscr...@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+unsubscr...@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
