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