numeric amount in word figers

[Waqas]

hi there,

i m trying to make some fuction which write my numeric values in text..
like

$5000= Five Thousand Dollars Only..

can somebody help me

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software! Free Support at
http://www.ozgrid.com/forum/ **

 

[Debra Dalgleish]

You can do this with a user defined function. There are instructions in
the following MSKB article:

How to convert a numeric value into English words in Excel
http://support.microsoft.com/kb/q213360/

 

[John Kitchens]

Hello,
Go to this link and follow the instructions. It works great.

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

Sincerely,

John Kitchens