You could do it through either a macro or a workbook formula, but this
is easier:

Select your column of dates. Choose Data/Text to Columns. Click Next,
Next. Choose YMD in the Date dropdown, click Finish.

Format the column as you wish.

In article ,
MichaelR wrote:

Hi,

I'm trying to format a system generated file to be more user friendly. The
file outputs dates like this: 20080714. Is there any way that I can change
the format to 07/14/2008 through a macro or a worksheet formula? I tried to
format the cells as dates but it didn't work.

Any ideas would be greatly appreciated.

Thanks!
Michael