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

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

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