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?
Best regards,
LM MUSCAT
FRANCE
----- Original Message -----
From: <[email protected]>
To: <[email protected]>
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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
