Convert dollar values to text

[RBorg]

Is there a way to convert dollar values to text?
Example: If Cell A1 has a value of $2,842.00, then cell B1 needs to read as "Two Thousand Eight Hundred Forty Two Dollors & Zero Cents"

Any suggestions

 

[PaddyD]

several. download the morefunc addin (see the 'links etc' thread at the top of the forum). it's got a numtext() function that does what you need.

 

[RBorg]

Paddy,
Thanks for the speedy reply. This may seem stupid but I can't see "links etc" at the top of the forum. Do I need to go to another screen for this ?

 

[PaddyD]

http://www.mrexcel.com/board2/viewtopic.php?t=49750

 

[RBorg]

Got it! That's exactly what I need. Unfortunately the download site http://longre.free.fr/english/ is not responding or can't be found. Do you know another site that might have this addin? Thanks again for your help!!

 

[RBorg]

Paddy,
The site finally came up and I got the download. Thanks again :D