One column at a time:

Select that column
Data|text to columns
choose YMD as the field type
Format|cells|number tab
and give it the format you like best.



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