T

Presuming data in column A, use a new empty column and enter

=DATEVALUE(MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4))

and format the resulting number as a sate, via FormatCells...Number

You can then copy these new dates and Paste Special...Values and number
formats over the old ones

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"T" wrote in message
...
If a date has been entered 20051103, is there a way to convert it to
11/03/2005?