Hi,
Sorry the fonction doesn't exist!! In the french package.
You have to create a "macro" to do this.
Best regards,
Louis-Marc MUSCAT
----- Original Message -----
From: <subratan...@punjlloyd.com>
To: <users@openoffice.org>
Sent: Friday, December 18, 2009 3:45 AM
Subject: Re: [users] number to text conversion
Sir,
"Is I understand?" --> yes that's correct.
It was a silly mistake while typing 201 it appeared 21. sorry...
Also, sorry.... for late reply... (some urgent personal reasons I was out
of touch)
With Regards,
SUBRATA NATH
SNX27, Silchar.
"Louis-Marc Muscat" <muscat.louis-m...@neuf.fr>
12/14/2009 01:58 PM
To
<subratan...@punjlloyd.com>
cc
Subject
Re: [users] number to text conversion
Hi,
I use all the times numeric formats, please try to explain:
21 written in (A1) then (by a function) in (B2) displays "Two Hundred and
One" or "Two Zero One" (with letters).
Is I understand? Because I don't know why 21 gives 201. I think 201
(numeric) gives "Two Hundred and
One" or "Two Zero One" (with letters).
Best regards,
LM MUSCAT
FRANCE
----- Original Message -----
From: <subratan...@punjlloyd.com>
To: <users@openoffice.org>
Sent: Monday, December 14, 2009 5:47 AM
Subject: [users] number to text conversion
Sir,
I want to know that how can I get a text (character) to a numeric value.
Say "201" to be as "Two Hundred and One" or "Two Zero One".
ie. if a Cell (Say A1) is entered with a numeric value "21" then in Cell
(say B1) will display "Two Hundred and One" or "Two Zero One".
Thanks to all for the support always extended.
With Regards,
SUBRATA NATH
SNX27, Silchar.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. If you are not the intended recipient of this communication,
we
request you to notify the sender immediately by return email and destroy
all
copies and the original message. Any unauthorized review, use, disclosure,
dissemination, forwarding, printing or copying of this email is strictly
prohibited. The recipient acknowledges that Punj Lloyd Limited or its
subsidiaries and associated companies (collectively "Punj Lloyd Group")
are
unable to exercise control or ensure or guarantee the integrity of/over
the
contents of the information contained in e-mail transmissions and further
acknowledges that any view, opinion or advice expressed in this message
are
those of the individual sender and no binding nature of the message shall
be
implied or assumed unless the sender does so expressly with due authority
of
Punj Lloyd Group. Although we have taken all reasonable precautions to
ensure that this communication is free from viruses. We do not assume
responsibility for any loss or damage arising from the use of this email.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. If you are not the intended recipient of this communication, we
request you to notify the sender immediately by return email and destroy all
copies and the original message. Any unauthorized review, use, disclosure,
dissemination, forwarding, printing or copying of this email is strictly
prohibited. The recipient acknowledges that Punj Lloyd Limited or its
subsidiaries and associated companies (collectively "Punj Lloyd Group") are
unable to exercise control or ensure or guarantee the integrity of/over the
contents of the information contained in e-mail transmissions and further
acknowledges that any view, opinion or advice expressed in this message are
those of the individual sender and no binding nature of the message shall be
implied or assumed unless the sender does so expressly with due authority of
Punj Lloyd Group. Although we have taken all reasonable precautions to
ensure that this communication is free from viruses. We do not assume
responsibility for any loss or damage arising from the use of this email.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org