Convert numbers (numerals) to words (text)

[Yard Sale]

Could anyone recommend a pre-built macro or other tool that converts a
number into english words, allowing for precision to three decimal
places?

I'd like the result to be:

-987.654- converts to "nine hundred eighty-seven and six hundred
fifty-four thousandths"

Thanks for any help!

 

[Niek Otten]

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


Niek Otten

|
| Could anyone recommend a pre-built macro or other tool that converts a
| number into english words, allowing for precision to three decimal
| places?
|
| I'd like the result to be:
|
| -987.654- converts to "nine hundred eighty-seven and six hundred
| fifty-four thousandths"
|
| Thanks for any help!
|
|
| --
| Yard Sale
| ------------------------------------------------------------------------
| Yard Sale's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36084
| View this thread: http://www.excelforum.com/showthread.php?threadid=558680
|

 

[Yard Sale]

Niek, I've been to all the links on the page you linked to, and none o
them work. The french one comes close, but will only do hundreths, no
thousandths, so that 5.663 converts to "five and sixty-six hundredths
instead of "five and sixty hundred sixty-three thousandths."

Thanks for being the first to reply, though

 

[Niek Otten]

I didn't read your question carefully enough, turns out now.
I'm not aware of any utility that spells fractions beyond "cents".
Sorry!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Niek, I've been to all the links on the page you linked to, and none of
| them work. The french one comes close, but will only do hundreths, not
| thousandths, so that 5.663 converts to "five and sixty-six hundredths"
| instead of "five and sixty hundred sixty-three thousandths."
|
| Thanks for being the first to reply, though!
|
|
| --
| Yard Sale
| ------------------------------------------------------------------------
| Yard Sale's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36084
| View this thread: http://www.excelforum.com/showthread.php?threadid=558680
|