How can I change Numbers in WOrds in Excel

How Can I Change the Numbers to Words in Excel.
Eg I want to chnge 9001 to "Nine Thousand and One Only"

Hi

Excel has no built-in method for this. Use Laurent Longre's addin Morefunc:
http://xcell05.free.fr/

HTH. Best wishes Harald


"A J" <A J@discussions.microsoft.com> skrev i melding
news:C963FCAD-96A5-43E5-B053-684E9BF3E977@microsoft.com...
> How Can I Change the Numbers to Words in Excel.
> Eg I want to chnge 9001 to "Nine Thousand and One Only"
>

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

--
HTH

Bob Phillips

"A J" <A J@discussions.microsoft.com> wrote in message
news:C963FCAD-96A5-43E5-B053-684E9BF3E977@microsoft.com...
> How Can I Change the Numbers to Words in Excel.
> Eg I want to chnge 9001 to "Nine Thousand and One Only"
>

This file might be a help:
http://www.bygsoftware.com/examples/...s/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


"A J" <A J@discussions.microsoft.com> wrote in message
news:C963FCAD-96A5-43E5-B053-684E9BF3E977@microsoft.com...
> How Can I Change the Numbers to Words in Excel.
> Eg I want to chnge 9001 to "Nine Thousand and One Only"
>