Check out Bob Phillips' site for methods.

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


Gord Dibben MS Excel MVP

On Fri, 27 Jul 2007 12:06:03 -0700, wflenner
wrote:

I need a formula that will convert data such as 1234 and display it as one
thousand two hundred thirty-four...one that is like bahttext but that is
displayed in english