|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 24th, 2010, 04:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
120= rupees one hundred twenty only
i just want to know the formula which translate digit to text for example if
120 written in any cell and other cell we want result "rupees one hundred twenty only" 
|
|
#2
May 25th, 2010, 01:22 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
120= rupees one hundred twenty only
See one or more of these
Excel converting numbers to text http://support.microsoft.com/default...b;en-us;213360 http://www.codearchive.com/code/0200...xtfunction.txt http://www.xldynamic.com/source/xld.xlFAQ0004.html http://www.ozgrid.com/VBA/ValueToWords.htm best wishes -- Bernard Liengme Microsoft Excel MVP people.stfx.ca/bliengme email address: remove uppercase characters REMEMBER: Microsoft is closing the newsgroups; We will all meet again at http://answers.microsoft.com/en-us/o...ult.aspx#tab=4 "digit to text" digit to wrote in message ... i just want to know the formula which translate digit to text for example if 120 written in any cell and other cell we want result "rupees one hundred twenty only"
|
|
#3
May 25th, 2010, 06:46 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
120= rupees one hundred twenty only
digit to text;955747 Wrote: i just want to know the formula which translate digit to text for example if 120 written in any cell and other cell we want result "rupees one hundred twenty only" an excel add in, that shows numeric to indian format words. http://tinyurl.com/22m77xw all the best -- bala_vb
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
