Written number amounts

[ajchapaiii]

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

 

[Gary''s Student]

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

 

[Luke M]

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

http://support.microsoft.com/kb/213360

 

[ajchapaiii]

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

 

[ajchapaiii]

this worked great

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!*