Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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=558680 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers (numerals) to words (text)
http://xldynamic.com/source/xld.xlFAQ0004.html
Niek Otten "Yard Sale" wrote in message ... | | 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=558680 | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers (numerals) to words (text)
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...o&userid=36084 View this thread: http://www.excelforum.com/showthread...hreadid=558680 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert numbers (numerals) to words (text)
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 "Yard Sale" wrote in message ... | | 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...o&userid=36084 | View this thread: http://www.excelforum.com/showthread...hreadid=558680 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert text to numbers | Excel Discussion (Misc queries) | |||
can i convert numbers to text automatically | Excel Worksheet Functions | |||
How do I convert text to numbers in an old version of excel | Excel Worksheet Functions | |||
how to convert decimal numbers to words | Excel Worksheet Functions | |||
convert numbers to text | Excel Discussion (Misc queries) |