Please download and install
http://extensions.libreoffice.org/extension-center/numbertext-1
I needed to format a number to written (long-hand) for a check. This did
produce what was needed.
When using MONEYTEXT(), reference your cell with the number in it.
Although the command asks for
That extension worked for me both for NumberText and MoneyText.
In my previous post I'd was talking about version 0.9.4. I didn't realise there
was a newer version!
Alex
On Tuesday 25 Feb 2014 13:45:41 Paul D. Mirowsky wrote:
Please download and install
On Tue, Feb 25, 2014 at 1:45 PM, Paul D. Mirowsky
p_mirow...@bentaxna.comwrote:
Please download and install
http://extensions.libreoffice.org/extension-center/numbertext-1
Very nice. I've installed it.
If I could change the extension (maybe I will try) I would make optional or
remove the
On February 25, 2014 1:57:49 PM PST, Alan B abo...@gmail.com wrote:
On Tue, Feb 25, 2014 at 1:45 PM, Paul D. Mirowsky
p_mirow...@bentaxna.comwrote:
Please download and install
http://extensions.libreoffice.org/extension-center/numbertext-1
Very nice. I've installed it.
If I
On Tue, Feb 25, 2014 at 8:09 PM, James E Lang jim+...@lang.hm wrote:
I believe the traditional way to write this on a check is, Thirty-five
and 50/100 dollars
Good point. That's certainly the way I've done it. And the word dollars
is preprinted on the checks I've used so the program output
On 23/02/2014, Tanstaafl tansta...@libertytrek.org wrote:
Tom, please do NOT CC me directly, I am on the list and certainly don't
need to see your messages twice.
On 2014-02-22 7:01 PM, Tom Davies tomc...@gmail.com wrote:
As the User Support mailing list for a gateway project i think it's
Dennis,
It looks to me that you're asking how to convert a number to the words that
are spoken to say that number.
You've asked how to convert a number ... to text. People familiar with
programming/macros and data types will read that and think of something
different than creating the words to
2014-02-23 4:08 GMT+01:00 Andrew Douglas Pitonyak and...@pitonyak.org:
On 02/22/2014 04:41 PM, Tanstaafl wrote:
It is called bottom or in-line posting, and is preferred by the more
technically inclined.
Bottom and Top posting seems to be a personal preference often pursued
with religious
Tom, please do NOT CC me directly, I am on the list and certainly don't
need to see your messages twice.
On 2014-02-22 7:01 PM, Tom Davies tomc...@gmail.com wrote:
As the User Support mailing list for a gateway project i think it's
fairly good that we help people to learn that there are
On 2014-02-23 10:40 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote:
I don't use an email client, but the Gmail web interface also hides lines
from previous posts.
Lol! Thanks for the laugh Johnny...
In case you are wondering, the funny bit is how quickly you disproved
your very first
2014-02-23 18:05 GMT+01:00 Tanstaafl tansta...@libertytrek.org:
On 2014-02-23 10:40 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote:
I don't use an email client, but the Gmail web interface also hides lines
from previous posts.
Lol! Thanks for the laugh Johnny...
childishness
Don't
On Sun, 23 Feb 2014, Johnny Rosenberg wrote:
[...]
P.S. Google Translate was used several times when I wrote the crap above,
and still I didn't get it right… I know, nobody wants to know, but those
didn't read this anyway.
D.S.
whatever, your English is pretty much as good as the native
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
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
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
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
On 2014-02-22 4:28 PM, Johnny Rosenberg gurus.knu...@gmail.com wrote:
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
Here we go again.
There is top-posting, which is, in general, a good thing, and is preferred by
most email users, including the technically inclined, like myself. Its primary
advantage is that it is a great courtesy to the readers of email threads, who
can quickly assess a contribution to the
On 02/22/2014 04:41 PM, Tanstaafl wrote:
It is called bottom or in-line posting, and is preferred by the more
technically inclined.
Bottom and Top posting seems to be a personal preference often pursued
with religious zeal (as you mention below). While quickly browsing, top
posting is
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
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
, 2014 6:04 AM
To: users@global.libreoffice.org
Cc: dennispreg...@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
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 menuCellsNumbers tabCategoryText OK.
Cristi
On 21/02/2014 09:55, Dennis Regan wrote:
MY EMAIL ADDRESS IS:
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
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
25 matches
Mail list logo
