See Bob Phillips' site for details on how to do this.

Several different methods you could use.

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


Gord Dibben MS Excel MVP


On Tue, 13 Feb 2007 15:18:01 -0800, ChaosDragon2007
wrote:

My problem is that i want the cell to display a alpha value after i have
enter a numberic value. For example, if I enter "10" in cell A1 then I want
cell B1 to display "ten" and if i enter 100 for cell A2 then cell B2 should
automatic display "One hundred".

Is there an easier way or a formula to do this instead of having to go
through each cell and write down everything? Thank in advanced.