converting numerical data in one cell to word data in another cell

[Vishnu]

How to convert the cell reference of numerical data to word format
automatically. Is there any provision available with Microsoft Excel.

 

[muddan madhu]

u r telling if A1 has 10 then in B1 should in words as Ten ?

Check this one http://support.microsoft.com/kb/213360

 

[ryguy7272]

Take a look at this:
http://www.xldynamic.com/source/xld.xlFAQ0004.html

You may need to read this too:
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm#Creating_Your_First_Macro



Regards,
Ryan---