digit to word conversion

Sir,

I would like to know about the conversion of a digit into word.

The question is :

How is a digit entered in a cell converted into its corresponding words.

For Example:

"123456" into "one lakh twenty three thousand four hundred and fifty six"

Please mail me your valuable suggestions

Arun

Hi there,

Click here http://support.microsoft.com/kb/213360 where Microsoft have created a user defined function (udf) for just this purpose.

HTH

Robert