Re: $$Excel-Macros$$ Solustion for Num2text formula

2011-03-11 Thread Paul Schreiner
l From: ashish koul To: excel-macros@googlegroups.com Sent: Fri, March 11, 2011 10:10:56 AM Subject: Re: $$Excel-Macros$$ Solustion for Num2text formula try this =ROUND(SUM(E23:E33),"0.00") On Fri, Mar 11, 2011 at 6:30 PM, manhar prajapati wro

Re: $$Excel-Macros$$ Solustion for Num2text formula

2011-03-11 Thread ashish koul
try this =ROUND(SUM(E23:E33),"0.00") On Fri, Mar 11, 2011 at 6:30 PM, manhar prajapati < prajapati.man...@gmail.com> wrote: > Hi > > Thanks you for reply. > > But i Require the last amount is calcualte in 2 desibal it means if the > number is 100.5201 its calcualate only 100.52 so when i round o

Re: $$Excel-Macros$$ Solustion for Num2text formula

2011-03-11 Thread manhar prajapati
Hi Thanks you for reply. But i Require the last amount is calcualte in 2 desibal it means if the number is 100.5201 its calcualate only 100.52 so when i round of the amount as +.48 its comes 101. For more details please look Attach file Regards Manhar. On Fri, Mar 11, 2011 at 5:00 PM, NOO

Re: $$Excel-Macros$$ Solustion for Num2text formula

2011-03-11 Thread NOORAIN ANSARI
Dear Manhar, Please see attachment... On Fri, Mar 11, 2011 at 12:59 PM, manhar prajapati < prajapati.man...@gmail.com> wrote: > Dear all > > Please help me in attach file the problam are mention in attach file and > require the help for it. > > > Require help immediate. > > Thanks & Regards > Ma