Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting number to words
hot to convert numeric number to word ?
e.g. 10 to TEN |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting number to words
Look he
http://xldynamic.com/source/xld.xlFAQ0004.html "Prashant Mhapankar" wrote: hot to convert numeric number to word ? e.g. 10 to TEN |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting number to words
Thanks for the following.
But i require plain conversion...the link provides conversion to Currency mode. Please help for getting code for convertion just plain number to words e.g. 115225 = ONE LAKH FIFTEEN THOUSAND TWO HUNDRED TWENTY FIVE I AM NOT EXPERT IN MODIFYING THE CODE SO PLEASE HELP. "Toppers" wrote: Look he http://xldynamic.com/source/xld.xlFAQ0004.html "Prashant Mhapankar" wrote: hot to convert numeric number to word ? e.g. 10 to TEN |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting number to words
Hello,
You can ignore currency info this way: =LEFT(spellnumber(A1),FIND(" Dollar",spellnumber(A1))-1) I suggest to take my UDF spellnumber: http://www.sulprobil.com/html/spellnumber.html If you want to try other programs published in the web I suggest to test them with input -1. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting numbers to words | Excel Discussion (Misc queries) | |||
Converting equations into easy-to-understand words?! | Excel Discussion (Misc queries) | |||
converting number to figures in words | Excel Discussion (Misc queries) | |||
Converting words to numbers | Excel Discussion (Misc queries) | |||
Converting numbers into words? | Excel Discussion (Misc queries) |