2014-02-22 11:39 GMT+01:00 Tom Davies <[email protected]>: > 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 > <[email protected]> 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 <[email protected]> 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: [email protected] > >> >> > >> >> 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 >
Off topic, but I'm just so surprised that nobody complained about shouting (using upper case letters)… and about top posting. Johnny Rosenberg -- To unsubscribe e-mail to: [email protected] 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
