That got me closer, Jim. I tried #NumberFormat(Trim(Get_Property_Details.Sale_Price), "999999999999999")# and it did take off the decimal and rounded the number to 255900, however the 255900 was then preceded by about 4 blank spaces in the form field.
And to think I was trying to round the number to help overcome a problem with JS validation! :oP Rick -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:29 PM To: CF-Talk Subject: Re: What is wrong with this? Ashish Gohri wrote: > Something like this works - > <cfset a = NumberFormat("1234567","9999")> > I believe in older CF versions (5 maybe, 4.5 for sure), you had to have as many places (or more) in your mask as you had in the number it is formatting. Is this a older version of CF? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272428 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
