Fill the values by '####' or unknown, then convert it Sometimes we can't convert before fill or drop the missing data if its a lot