Chucky

Assuming your data is coming in like 20051231 or similar.

Try DataText to ColumnsNextNextColumn Data FormatDate and pick the
appropriate format then Finish.

You will have to then format the cells to your MM/DD/YYYY format.


Gord Dibben Excel MVP

On Wed, 19 Jan 2005 13:17:23 -0800, 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.