I'm pulling in an unformatted 8-digit date field from an AS400 into an excel
spreadsheet. I would like to be able to format it in MM/DD/YYYY format in the
spreadsheet, but get weird numbers when I do so. I don't see anything in the
standard date formatting section and have created a Custom Format as
' / / ', but this will not work either.