I am importing a tab delimited file into Excel and there are a
couple for field that are not importing correctly. The first field is a
date field formatted as YYYYMMDD and Excel thinks it is a number.
I need it to translate to MM/DD/YYYY. The second field is a Time
field formatted as military time without any separators - 1600 =
4:00 PM. What would be the simplest way to solve these issues?

Thanks in advance.