Formula to convert dollar amount to text

go2jared

New Member
Joined
Aug 21, 2004
Messages
33
I know this question has been asked before...and have tried to use the answers given...but it doen't seem to be working for me.

In cell C10, I have the dollar amount $12,426.75. In cell D10, I want it to convert this number to (Twelve-thousand four hundred twenty six dollars and 75 cents).

I am using MS Excel 2003 SP2. Is there a simple formula that I can just paste into cell D10, without needing VBA script?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
If you have the latest version of the morefunc.xll add-in:

=NBTEXT(A1,,,"dollar","dollars","cent","cents")
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,505
Members
412,671
Latest member
vitaminshop20
Top