coerce numeric values from text field, some cleanup