ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Convert numbers (numerals) to words (text) (https://www.excelbanter.com/excel-programming/366368-convert-numbers-numerals-words-text.html)

Yard Sale[_2_]

Convert numbers (numerals) to words (text)
 

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...o&userid=36084
View this thread: http://www.excelforum.com/showthread...hreadid=558681


Franz Verga

Convert numbers (numerals) to words (text)
 
Yard Sale wrote:
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!



Triy this, from MS KB:

http://support.microsoft.com/default...;EN-US;q213360

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy




All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com