Doubt

QuestionEdit

How to change 500(in numerical form) toform using a function or formulae?

AnswerEdit

1st and Good Method:-

Follow the below link and download the MoreFuction Addin from that and run the setup.

http://download.cnet.com/Morefunc/3000-2077_4-10423159.html

After doing that openand goto

Tools>>Add-Ins>Check the Morefunc(add-in Function)>>Ok Then go to

Insert>>Functions>>Select a Category>>Select Morefun>>Select a Funcion:>>Select NBTEXT>>Ok

Other Methods:-

Have a look in the below links

http://support.microsoft.com/kb/213360 http://www.ozgrid.com/VBA/ValueToWords.htm http://www.xldynamic.com/source/xld.xlFAQ0004.html