Amount to text

JCLSB · Sep 16, 2006

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 · Sep 16, 2006

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