need formula help!

[Guest]

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.

 

[Gord Dibben]

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

 

[Guest]

see:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&