Hi, Thanks for sending me an email, but unfortunately, you'll have to send it again.
Please send emails to [EMAIL PROTECTED] from now on. Thanks, Scott Arbeitman -----Original Message----- Reply-To: cfaussie@googlegroups.com From: "Rod Higgins" <[EMAIL PROTECTED]> To: <cfaussie@googlegroups.com> Subject: [cfaussie] Re: decimal places Date: Mon, 18 Sep 2006 11:47:24 +1000 > ------=_NextPart_000_0009_01C6DB18.389D78A0 > Content-Type: text/plain > Content-Transfer-Encoding: quoted-printable > numberformat(mynumber, '9.999') > =20 > hth > Rod > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf > Of Tom MacKean > Sent: Monday, 18 September 2006 11:43 AM > To: cfaussie@googlegroups.com > Subject: [cfaussie] decimal places > Hi List, > =20 > How do I round a number to a certain number of decimal places (in this case > three). > =20 > e.g. .666666666666 should become .667 and .1 should become .100 > =20 > I can't seem to find a function that does it. > =20 > Thanks, > =20 > Tom > --=20 > IMPORTANT: This email is intended for the use of the individual addressee(s) > named above and may contain information that is confidential privileged or > unsuitable for overly sensitive persons with low self-esteem, no sense of > humor or irrational religious beliefs. If you are not the intended > recipient, any dissemination, distribution or copying of this email is not > authorized (either explicitly or implicitly) and constitutes an irritating > social fauxpas. No animals were harmed in the transmission of this email, > although the mutt next door is living on borrowed time, let me tell you.=20 > > ------=_NextPart_000_0009_01C6DB18.389D78A0 > Content-Type: text/html > Content-Transfer-Encoding: quoted-printable > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Dus-ascii"> > <TITLE>Message</TITLE> > <META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR></HEAD> > <BODY> > <DIV><SPAN class=3D266334601-18092006><FONT face=3DArial color=3D#0000ff=20 > size=3D2>numberformat(mynumber, '9.999')</FONT></SPAN></DIV> > <DIV><SPAN class=3D266334601-18092006><FONT face=3DArial color=3D#0000ff=20 > size=3D2></FONT></SPAN> </DIV> > <DIV><SPAN class=3D266334601-18092006><FONT face=3DArial color=3D#0000ff=20 > size=3D2>hth</FONT></SPAN></DIV> > <DIV><SPAN class=3D266334601-18092006><FONT face=3DArial color=3D#0000ff=20 > size=3D2>Rod</FONT></SPAN></DIV> > <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px"> > <DIV></DIV> > <DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft><FO= > NT=20 > face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B>=20 > cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] <B>On Behalf= > Of=20 > </B>Tom MacKean<BR><B>Sent:</B> Monday, 18 September 2006 11:43=20 > AM<BR><B>To:</B> cfaussie@googlegroups.com<BR><B>Subject:</B> [cfaussie]= > =20 > decimal places<BR><BR></FONT></DIV> > <DIV>Hi List,</DIV> > <DIV> </DIV> > <DIV>How do I round a number to a certain number of decimal places (in th= > is=20 > case three).</DIV> > <DIV> </DIV> > <DIV>e.g. .666666666666 should become .667 and .1 should become .100</DIV> > <DIV> </DIV> > <DIV>I can't seem to find a function that does it.</DIV> > <DIV> </DIV> > <DIV>Thanks,</DIV> > <DIV> </DIV> > <DIV>Tom<BR clear=3Dall><BR>-- <BR>IMPORTANT: This email is intended for = > the use=20 > of the individual addressee(s) named above and may contain information th= > at is=20 > confidential privileged or unsuitable for overly sensitive persons with l= > ow=20 > self-esteem, no sense of humor or irrational religious beliefs. If you ar= > e not=20 > the intended recipient, any dissemination, distribution or copying of thi= > s=20 > email is not authorized (either explicitly or implicitly) and constitutes= > an=20 > irritating social fauxpas. No animals were harmed in the transmission of = > this=20 > email, although the mutt next door is living on borrowed time, let me tel= > l=20 > you. </DIV><BR><br> > --~--~---------~--~----~------------~-------~--~----~<br> > You received this message because you are subscribed to the Google Groups &= > quot;cfaussie" group. <br> To post to this group, send email to cfauss= > [EMAIL PROTECTED] <br> To unsubscribe from this group, send email to cfau= > [EMAIL PROTECTED] <br> For more options, visit this group a= > t http://groups.google.com/group/cfaussie <br> -~----------~----~----~----~= > ------~----~------~--~---<br> > <br> > ------=_NextPart_000_0009_01C6DB18.389D78A0-- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie -~----------~----~----~----~------~----~------~--~---
