Amount to text

[JCLSB]

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]

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

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

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