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

Hi Dennis,

What format will the numbers themselves be entered in?

In addition to "TEXT" you can also use the "DOLLAR" function, which
will use your localization information to format the number as text
string with a currency symbol, thousands separator and decimal places.
To use the "TEXT" function, you can use a format string of "$#,#.##" to
get those things as well.

I know of no way to get the number written out as words, at least not
with stock Calc.

This question (see URL [1]) on ask.libreoffice.org discusses
this, and three possible solutions are given:

* This add-on (see URL [2]), but it seems that it is no longer
  maintained, and may not work for the latest versions of LO. I haven't
  tried it, so you'll have to see for yourself.
* There is also mention of this Microsoft article that gives some macro
  code for Excel (see URL [3]), which presumably could be converted to
  work with Calc.
* Some code is also given, presumably for LO Basic, but it seems to be
  for Indian currency. This could probably also be converted to your
  currency of choice.

[1]http://ask.libreoffice.org/en/question/1194/convert-numbers-to-english-words/
[2]http://extensions.libreoffice.org/extension-center/numbertext-1
[3]http://support.microsoft.com/kb/213360

So in short there seems to be no easy way of doing this. You might find
that the extension works for you, or you might have to write a macro to
do this, using one of the two examples as a starting point.

Hope this helped.

Paul


On Fri, 21 Feb 2014 06:13:58 -0500
"Dennis Regan" <DennisPRegan2@hotmail.com> wrote:

> FOR CLARITY TO MY SPREADSHEET READERS I WOULD LIKE NUMBERS TO READ IN
> TWO DIFFERENT WAYS:
>
> +) $2,000
>
> +) TWO THOUSAND DOLLARS
>
> IS THIS POSSIBLE?
>
> -----Original Message----- 
> From: Paul
> Sent: Friday, February 21, 2014 6:04 AM
> To: users@global.libreoffice.org
> Cc: DennisPRegan2@hotmail.com
> Subject: Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN
> LibreOffice CALC TO TEXT IN LibreOffice CALC?
>
> I think the formula you want is "TEXT".
>
> I'm not too sure on the format parameter to this function, haven't
> checked that, but for me a format string of "#.##" worked fine for a
> number with a decimal place. You should be able to find further
> details of the format string in the help or online.
>
> So, for example, I put the number "1234.5" in cell A1, then in cell B1
> I put the formula '=TEXT(A1,"#.##")', and now cell B1 holds the text
> string "1234.5".
>
> I hope this is what you were looking for.
>
> Paul
>
>
>
> On Fri, 21 Feb 2014 02:55:53 -0500
> "Dennis Regan" <DennisPRegan2@hotmail.com> 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