Convert amount in cell to words

[Raj Shah]

hi
pls help me with the formula to convert amount in cell to words like it
shows sometimes on commercial invoices
thanks
raj

 

[davesexcel]

http://www.meadinkent.co.uk/xlnumberstext.htm

This Web Site has the function you request

once you have copied and pasted the code into a module, the formula
will be =WordNum(A1) if your value is in A1

 

[Paul B]

Raj, have a look here, http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Raj Shah]

many thanks
raj

http://www.meadinkent.co.uk/xlnumberstext.htm

This Web Site has the function you request

once you have copied and pasted the code into a module, the formul
will be =WordNum(A1) if your value is in A

 

[Raj Shah]

many thanks
raj

Raj, have a look here
http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit fro
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Raj Shah" <[email protected]> wrot
in
message news:[email protected]...
http://www.excelforum.com/showthread.php?threadid=534075