Is there any way to convert digits in one cell to word values in?...Also give
examples.

Hi,

There are several bits of code about that will do this but one excellent
solution is to instal the Excel addin 'Morefunc' which is free and contains
many useful functions including one called =NBTEXT() which will convert a
number to text. The addin is very easy to install.

Mike

"Abhijit Saha" wrote:

Is there any way to convert digits in one cell to word values in?...Also give
examples.

It would have been helful if I had posted the link

http://xcell05.free.fr/english/

Mike

"Abhijit Saha" wrote:

Is there any way to convert digits in one cell to word values in?...Also give
examples.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Abhijit Saha" <Abhijit wrote in message
...
Is there any way to convert digits in one cell to word values in?...Also
give
examples.

Hi

I have a non-macro solution on my site -
http://ashishmathur.com/solutions.aspx. Please navigate to question 9

--
Regards,

Ashish Mathur
www.ashishmathur.com
http://www.linkedin.com/in/excelenthusiasts

"Abhijit Saha" <Abhijit wrote in message
...
Is there any way to convert digits in one cell to word values in?...Also
give
examples.