2014-02-22 21:32 GMT+01:00 Paul <paulste...@afrihost.co.za>: > > Off topic, but I'm just so surprised that nobody complained about > > shouting (using upper case letters)… and about top posting. > > > > > > Johnny Rosenberg > > Well, as to the shouting, I guess I kind of assumed the OP was new to > this, and didn't want to criticize, but you're right, somebody should > have corrected him. >
Well, let's say ”informed him”, in a nice way, of course. > > Top posting is the preferred way to reply. At least for me. I really > don't understand why some people insist on bottom posting and making > the lives of everyone reading the thread more difficult, but that's > just my opinion. So far this group hasn't tried to enforce a One Way Of > Doing Things (tm) on anybody, unlike some other groups I am subscribed > to. > I'm subscribed to a few groups myself, maybe I confused this one with the Apache OpenOffice one, but most of them seems to prefer everything but top posting. Personally I prefer this way, I'm not sure what to call it, but I'm doing it right now… Johnny Rosenberg > > Paul > > > On Sat, 22 Feb 2014 19:51:17 +0100 > Johnny Rosenberg <gurus.knu...@gmail.com> wrote: > > > 2014-02-22 11:39 GMT+01:00 Tom Davies <tomc...@gmail.com>: > > > > > 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-libreoff...@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 <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 > > > > > > > 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: 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