Numberformat(number,".99") worked for my problem. Unless you specify a comma, numberformat will not put one in (with the exception of if you do not put in a mask). I didn't realize that decimalformat outputs a string value (that's what I get for not reading the manual hehehehe)
Eric -----Original Message----- From: Dawson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, 07 March 2006 08:23 To: CF-Talk Subject: RE: Ok, I give...how can I do this... I would use a regular expression to remove *all* non-numeric characters. Then, check to see if the remainder is numeric. You could do this both on the client and the server. M!ke -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, March 06, 2006 7:16 PM To: CF-Talk Subject: RE: Ok, I give...how can I do this... Thanks for the tip, Josh...yet another way I'll have to validate an entry. Maybe it's just easier to let them make an illegal entry, then tell them how I want them to enter the data than try to catch all the possible violations... I wonder what will happen if they enter $1,000 and I run it against IsNumeric(Replace(Form.Dollars, ",","","all")) ? What about that dollar sign? I'll have to see...thanks, Josh... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234580 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
