convert number to text xman123 <xman123.2cwhft_1156181108.1859[ at ]excelforum-nospam.com> 21.08.2006 17:24:52 how to :- 100 convert to One Hundred only and 100.30 convert to One Hundred and 30 Cent only -- xman123 ------------------------------------------------------------------------ xman123's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35532 View this thread: http://www.excelforum.com/showthread.php?threadid=573842

Re: convert number to text "Bob Phillips" <bob.NGs[ at ]somewhere.com> 21.08.2006 17:28:20 See http://www.xldynamic.com/source/xld.xlFAQ0004.html -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "xman123" <xman123.2cwhft_1156181108.1859[ at ]excelforum-nospam.com> wrote in message news:xman123.2cwhft_1156181108.1859[ at ]excelforum-nospam.com... [Quoted Text] > > how to :- > > 100 convert to One Hundred only > > and > 100.30 convert to One Hundred and 30 Cent only > > > -- > xman123 > ------------------------------------------------------------------------ > xman123's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35532 > View this thread: http://www.excelforum.com/showthread.php?threadid=573842 >