ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   decimal numbers to word (https://www.excelbanter.com/excel-worksheet-functions/220920-decimal-numbers-word.html)

Andreas[_2_]

decimal numbers to word
 
I need a code that converts decimal numbers to word. Example: 20.01
becomes" twenty and one tenth" I need this to read into the
thousandths. Example: 100.001 reads one hundred and one thousandth"

Shane Devenshire[_2_]

decimal numbers to word
 
Hi,

You can get free code to convert numerical entries to text, such as 123 to
One Hundred Twenty Three, at the following web site:

http://support.microsoft.com/kb/213360

You will probably need to modify it to meet your wording.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Andreas" wrote:

I need a code that converts decimal numbers to word. Example: 20.01
becomes" twenty and one tenth" I need this to read into the
thousandths. Example: 100.001 reads one hundred and one thousandth"



All times are GMT +1. The time now is 09:38 AM.

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