Remove decimal and trailing zeros added on Excel import and add placeholder values for LAS required fields.