thanks Chris, i get an error when using the regular expression that says the number 112221.111 cannot be converted to a number
this looks to be an interesting challenge for all of us! :) > >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:351726 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
