You might give LSParseNumber a try. It will take a string and give you a number and should deal with most common entry formats. There is also LSParseCurrency for dealing with things like $45.00
Cheers, Judah On Thu, May 13, 2010 at 10:28 AM, Robert Harrison <rob...@austin-williams.com> wrote: > > 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:333658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm