Chucky,
You'll need to use the date(year,month,day) function to convert to an excel
date. You can break down your data from the AS400 by using string functions.
Say the date is 02042005 in cell C7, then the formula would be
=DATE(RIGHT(C7,4),LEFT(C7,2),MID(C7,3,2)). You can then format it as you
wish.
Gary

"Chucky" wrote:

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.