Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
How can I sort mostly 3 decimal with some 4 decimal numbers | Excel Discussion (Misc queries) | |||
Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
EXCEL Decimal changes during WORD Merge | Excel Discussion (Misc queries) |