Convert Numbers (Digits) to Text.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need to know how can i conver Numbers / Figures to simple text, say, i have typed figure 100 in a cell, can it get convert to text "One Hundred" in the same or another cell ? If Yes, How ? Presently I'm using 2003 cofig
- Cheers, Praveen.
 
Thank You Frank,
But i cannot open these links, can you kindly mention the procedure if any in text format to me. I will be highly greatful to you.

- Thanx, Praveen
India.


----- Frank Kabel wrote: ----

H
some alternaives
MS Knowledge Base
http://support.microsoft.com/default.aspx?scid=KB;EN
US;21336
http://support.microsoft.com/default.aspx?scid=KB;EN
US;140704

Free Addin MOREFUNC-DLL which includes a UDF for this tas
(for variou
languages)
http://longre.free.fr/english

or have a look a
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zi
It's in the "Accountants" section on page
http://www.bygsoftware.com/examples/examples.ht
It contains two method

-
Regard
Frank Kabe
Frankfurt, German


Praveen Bhat wrote
 
the links work for me. Note: They have to be in one line
(remove the line wraps caused by your newsreader)
-----Original Message-----

Thank You Frank,
But i cannot open these links, can you kindly
Click to expand...
mention the procedure if any in text format to me. I will
be highly greatful to you.
 
Thank You Fran

- Praveen, India

----- Frank Kabel wrote: ----

the links work for me. Note: They have to be in one line
(remove the line wraps caused by your newsreader
-----Original Message----
But i cannot open these links, can you kindly
Click to expand...
mention the procedure if any in text format to me. I will
be highly greatful to you.
 
Back
Top