Try Data Text to Columns, it's easiest
Select just the col of "dates". Click Data Text to Columns. Click
NextNext. In step3, under "Col data format": Check "Date", choose: "YMD"
from the droplist, click Finish
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MichaelR" wrote:
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