Robert, You shouldn't have to strip it in a perfect world, but the comma makes it a string not a number according to ColdFusion.
Try this instead: $#numberFormat(val(my_number), "______.00")# Might not work, I didn't test it. Steve -----Original Message----- From: Robert Harrison [mailto:[email protected]] Sent: Thursday, May 13, 2010 1:28 PM To: cf-talk Subject: Convert to number This is just plain stupid. Client enters: 100,000.00 Formatting is: $#NumberFormat(my_number,"_______.00")# Cold Fusion Says: Cannot convert 100,000.00 to number. I have to be brain dead. There is no way I should have to strip commas, so what stupid thing am I doing? Just no seeing it right now. Thanks Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged __________ Information from ESET Smart Security, version of virus signature database 5113 (20100513) __________ The message was checked by ESET Smart Security. http://www.eset.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
