How to convert numbers to text format?

[Guest]

if i have

1 in cell a1, i need that to be changed into One in cell B1, how is this done?

regards

kishore

 

[Frederik]

Have a look at:

http://exceltips.vitalnews.com/Pages/T0351_Numbers_Spelled_Out.html

Success!!

 

[Guest]

See:

XL2000: How to Convert a Numeric Value into English Words
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360&;