Converting date from ASCII file to Excel format

[Sherry Akins]

Okay, this is a hard one and I haven't come up with any
viable solution. I have downloaded data in ASCII format
from our IBM AS400 system into an Excel worksheet. The
date field from the AS400 is written in YYYYMMDD form
(Example: 20040726) There are no separators in the date,
therefore, when it downloads into Excel it shows as text.
Because the year comes first, and there are no
separators, I can't find a way to make it come up in the
normal 4-digit year format that I need. (Example:
07/26/2004) I guess the bottom line is, how would I
convert this:

20040726 to 07/26/2004

There may not even be a way to do this, but if anybody
has any ideas, I'd be very grateful!

Thanks in advance!!!

 

[Myrna Larson]

If the file you are loading has a TXT extension, when you try to open it the
Text Wizard will open. There you can tell Excel how to handle the data in the
various columns. For the date column select the Date option and select the YMD
format.