Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

> 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.

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.

Paul


On Sat, 22 Feb 2014 19:51:17 +0100
Johnny Rosenberg <gurus.knugum@gmail.com> wrote:

> 2014-02-22 11:39 GMT+01:00 Tom Davies <tomcecf@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-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
>
> 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+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