Just so you know... desibal? If that was "decibel", it would be a unit of sound. (a ratio, actually) "Decimal" is the number of digits after the "dot" in a number.
Secondly.. the answer below: =round(sum(e23:e33),"0.00") will not work as expected. The second parameter for the round() function is supposed to be a NUMBER. instead of an error, in this case, Excel decides that the closes "number" to the string "0.00" is 0. so it rounds it to 0 decimal places. If you want 2 decimal places, then use: =round(sum(e23:e33),2) Paul ________________________________ From: ashish koul <koul.ash...@gmail.com> 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 <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 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, NOORAIN ANSARI <noorain.ans...@gmail.com> >wrote: > >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 >>>Manhar Prajapati >>>-- >>>---------------------------------------------------------------------------------- >>> >>>Some important links for excel users: >>>1. Follow us on TWITTER for tips tricks and links : >>>http://twitter.com/exceldailytip >>>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>3. Excel tutorials at http://www.excel-macros.blogspot.com/ >>>4. Learn VBA Macros at http://www.quickvba.blogspot.com/ >>>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/ >>> >>>To post to this group, send email to excel-macros@googlegroups.com >>> >>><><><><><><><><><><><><><><><><><><><><><><> >>>Like our page on facebook , Just follow below link >>>http://www.facebook.com/discussexcel >>> >> >> >>-- >> >>Thanks & regards, >>Noorain Ansari >> >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel