Amount to text
 

Hello,

Is there a formula to take a currency value in one cell and have it spell
out the amount?
If in one cell I have $28.32 is there a formula to have it put in
Twenty Eight and 32/100 like in a check?


Thank You

JCLSB

Amount to text
 

Bob Phillips has some links to methods of changing numbers to text.

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




On Fri, 15 Sep 2006 21:26:23 -0400, "JCLSB" wrote:

Hello,

Is there a formula to take a currency value in one cell and have it spell
out the amount?
If in one cell I have $28.32 is there a formula to have it put in
Twenty Eight and 32/100 like in a check?


Thank You

JCLSB


Gord Dibben MS Excel MVP