Mike

DataText to ColumnsNextNext. Column Data FormatDateYMD and Finish.

Your copied sample came out as desired.


Gord Dibben Excel MVP

On Fri, 18 Feb 2005 15:21:02 -0800, "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.