Data Conversion Error

I have a simple issue where people are doing data entry for numeric data.   The requirement is for them to enter whole numbers without punctation.   Since the data deals with dollars sometimes folks don't read and they want to enter things like dollar sign, comma, and decimal with cents.   This throws a data conversion error as the data is going into a numeric field and not a text field.   What do you do in this case?   I am using Coldfusion 10 with Msft SQL Server 2008.  

Thanks!   NC Beach Bum