How do I convert numerical into words ?

[Guest]

Dear Sir,

I am using Excel 2000. In the excel I want to conver my numeric total amount
into words. Please help me.

 

[Peo Sjoblom]

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360

 

[Bob Phillips]

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

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque writing
routines.

The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy