Convert Numbers (Digits) to Text.

P

Praveen Bhat

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.
 
F

Frank Kabel

P

Praveen Bhat

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
 
F

Frank Kabel

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.
 
P

Praveen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Need to extract text between numbers in a string 8
Converting Text 9
WORD VBA Search and switch to advanced ... 1
Word doc keeps changing to ALL CAPS 0
How do I convert shading to highlighting for specific colors 8
Special string convertion to date and time 5

Top