There's no built-in function in Excel to do this. You need to use a VBA macro,
either in a module in the workbook or in an add-in. You've been given links to
the latter, I believe.

On Fri, 26 Nov 2004 13:22:27 -0600, xcelentform
wrote:


I am a self admitted newbie, but I am unable to figure out how to
convert a number in one cell, to text in another cell, just like
writing out a check in a checkbook. If the numbers change, the text
changes as well. Thanks for all who help!