We are querying information from a ClearQuest database to produce a report in Crystal Reports. The field has been set as a text field because unfortunately that is the only way to caputure a decimal value (that we know of anyway) like 10.5. The field called ActualHrsComplete captures the hours that a test was worked on. Our report needs to total these hours. We used the ToNumber function to get a grand total on our report but we can no longer run the report since our users insist upon putting non-numeric values in the field like n/a, NA, none, etc. (despite the caption in the database that says "Numeric Values Only - n/a = 0"!). Is there a way I can pass the field through a script that would convert a field value that would only pull out numeric values and then we can convert with the ToNumber function?