>Kinda thought that's what the DecimalFormat function was all about. But now I am reminded that the DecimalFormat function always returns the two decimal places, in addition to the thousands separators. So, I would just run that result through a REReplace and be done with it:
<cfset FormattedValue = REReplace(DecimalFormat(InputNumeric), "\.00$", ""))> -Chris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351723 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm