Beautiful! That did the trick! Thank you. >From: Barney Boisvert <[EMAIL PROTECTED]> >Reply-To: [email protected] >To: CF-Talk <[email protected]> >Subject: Re: Decimal Formatting >Date: Tue, 12 Apr 2005 14:45:33 -0700 > >NUMBER columns are actually stored as strings, so you'll always get >exactly 2 decimal places. Try this: > ><cfif myNum EQ int(myNum)> > #int(myNum)# ><cfelse> > #REreplace(myNum, "0+$", "")# ></cfif> > >cheers, >barneyb > >On Apr 12, 2005 2:38 PM, B G <[EMAIL PROTECTED]> wrote: > > There's a simple solution here that is eluding me so please forgive my >"end > > of day cloud" that is obstructing me. > > > > I am trying to format a value that is stored in Oracle NUMBER(5,2) >datatype > > so that if it is a whole number it won't display x.00. > > > > For example, value 25.75 is fine and displays properly, value 18, should >NOT > > display 18.00. Likewise, 10.5 should NOT be 10.50. But this is the > > behaviour I am getting. > > > > What are you thoughts? > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/ > >Got Gmail? I have 50 invites. > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202499 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
