Ps. If you're importing this file (like File|open), you can choose YMD for that
field and save a little bit of time.

Mike Busch wrote:

I received a large ASCII format document that I imported into Excel. The date
appears as 19500323. Is there anyway to format this to read 03/23/1950.
thanks in advance.

--

Dave Peterson