Wow, I had completely NOT caught the spelling out portion of the initial
post! Call me Mr. Oversight

:-)

Shane

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Visit Bob Phillips' site for info on this subject.

Several links to methods, all of which involve VBA.

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


Gord Dibben MS Excel MVP

On Mon, 11 Dec 2006 09:14:00 -0800, jnu
wrote:

is there a formula or cell format so that when i type 389 in cell A1,
three
hundred and eighty-nine appears in cell b3