Format numbers to display as text

[JackiG]

Is there a way to have excel display a number as text? For example: 5 as Five or 155 as One Hundred Fifty Five

Thanks in advance for any suggestions!

[Ron Coderre]

Well....If you're comfortable with VBA, there is code you can adapt right in one of these forums at:

http://www.exceltip.com/st/Formulas_...Excel/301.html

The function definition is towards the bottom of that site.

Regards,
Ron

PS: The url keeps getting abbreviated above . So, if you have problems getting to the website...
On the home page, select Excel Tips and search for "loan payments"