I have a cell that has an amount in it i.e. $4,850.00.
In the cell next to it I have to write out the amount (like on a check) i.e.
Four Thousand Eight Hundred Fifty and NO/100.
Is there a way to format the second cell to automatically write out the
amount from the first cell??

Not through formatting alone.

You must use VBA.

See Bob Phillips' site for instructions and links.

http://www.xldynamic.com/source/xld.xlFAQ0004.html


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 14:30:01 -0700, DebbieSue
wrote:

I have a cell that has an amount in it i.e. $4,850.00.
In the cell next to it I have to write out the amount (like on a check) i.e.
Four Thousand Eight Hundred Fifty and NO/100.
Is there a way to format the second cell to automatically write out the
amount from the first cell??