Written number amounts
 

is it possible in excel to input a number (5) and produce/convert it to a
written amount (five)?

Written number amounts
 

=CHOOSE(A1+1,"zero","one","two","three","four","fi ve","six","seven","eight","nine",)

--
Gary''s Student - gsnu200903

Written number amounts
 

See article entitled "How to convert a numeric value into English words in
Excel"

http://support.microsoft.com/kb/213360
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ajchapaiii" wrote:

is it possible in excel to input a number (5) and produce/convert it to a
written amount (five)?

Written number amounts
 

thanks, however i needed something a bit more advance. What luke m submitted
was exactly what i needed

"Gary''s Student" wrote:

=CHOOSE(A1+1,"zero","one","two","three","four","fi ve","six","seven","eight","nine",)

--
Gary''s Student - gsnu200903

Written number amounts
 

this worked great

"Luke M" wrote:

See article entitled "How to convert a numeric value into English words in
Excel"

http://support.microsoft.com/kb/213360
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"ajchapaiii" wrote:

is it possible in excel to input a number (5) and produce/convert it to a
written amount (five)?