Alternatively use =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
If needed you could insert a column for this, then use Copy followed by
Paste Special-Values to convert formulas to dates; now delete the original
column
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rose" wrote in message
...
Can I change a date with no format ex: 20051111 to a date format ex:
11/11/2005?