Read the data dictionary before changing anything. It tells you whether a blank is allowed, which codes are valid and what unit a number is in. When the data contradicts the dictionary, record the conflict and ask; don't silently pick one.
Related: Schema, Data profiling, Validation rule